Re: ORA-00911 error and COMMIT

On Jun 16, 12:13=A0pm, William Maslin <CATmas...@[EMAIL PROTECTED]
> wrote:
> Hi,
>
> I'm been playing with using Filemaker Pro to generate and send sql to an
> Oracle 10g database. =A0The following works fine:
>
> UPDATE BEVIS_DL_TEST_RESULTS_ENTRY
>
> SET BEVIS_DL_TEST_RESULTS_ENTRY.RESULT_VALUE =3D 'A section of liver is
> examined microscopically. '
>
> WHERE BEVIS_DL_TEST_RESULTS_ENTRY.RESULT_NAME =3D 'HISTOPATHOLOGY' AND
>
> BEVIS_DL_TEST_RESULTS_ENTRY.ACCESSION_ID =3D '30257' AND
>
> BEVIS_DL_TEST_RESULTS_ENTRY.TEST_CODE =3D '6005';
>
> But when I add a COMMIT to the end I get an ORA-00911 error.
>
> UPDATE BEVIS_DL_TEST_RESULTS_ENTRY
>
> SET BEVIS_DL_TEST_RESULTS_ENTRY.RESULT_VALUE =3D 'A section of liver is
> examined microscopically. '
>
> WHERE BEVIS_DL_TEST_RESULTS_ENTRY.RESULT_NAME =3D 'HISTOPATHOLOGY' AND
>
> BEVIS_DL_TEST_RESULTS_ENTRY.ACCESSION_ID =3D '30257' AND
>
> BEVIS_DL_TEST_RESULTS_ENTRY.TEST_CODE =3D '6005';
>
> COMMIT;
>
> These statements are generated in Filemaker "calculation" fields in
> which text and field values are concatenated to produce statements like
> those above. =A0Please understand admit that I'm a complete Oracle and
SQL=

> novice. =A0The little that I've learned has come from SQL Visual
> Quickstart Guide and from hacking queries that I've stolen from Crystal
> Re****ts.
>
> Thanks!

It could be that it's executing them in a single dynamic SQL command
which should contain one command but it contains two. Try adding a
"BEGIN" at the beginning and an "END;" at the end.