Re: ORA-00911 error and COMMIT

On Jun 16, 12:13 pm, William Maslin <CATmas..._at_cvm.msstate.edu> wrote:
> Hi,
>
> I'm been playing with using Filemaker Pro to generate and send sql to an
> Oracle 10g database.  The following works fine:
>
> UPDATE BEVIS_DL_TEST_RESULTS_ENTRY
>
> SET BEVIS_DL_TEST_RESULTS_ENTRY.RESULT_VALUE = 'A section of liver is
> examined microscopically. '
>
> WHERE BEVIS_DL_TEST_RESULTS_ENTRY.RESULT_NAME = 'HISTOPATHOLOGY' AND
>
> BEVIS_DL_TEST_RESULTS_ENTRY.ACCESSION_ID = '30257' AND
>
> BEVIS_DL_TEST_RESULTS_ENTRY.TEST_CODE = '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 = 'A section of liver is
> examined microscopically. '
>
> WHERE BEVIS_DL_TEST_RESULTS_ENTRY.RESULT_NAME = 'HISTOPATHOLOGY' AND
>
> BEVIS_DL_TEST_RESULTS_ENTRY.ACCESSION_ID = '30257' AND
>
> BEVIS_DL_TEST_RESULTS_ENTRY.TEST_CODE = '6005';
>
> COMMIT;
>
> These statements are generated in Filemaker "calculation" fields in
> which text and field values are concatenated to produce statements like
> those above.  Please understand admit that I'm a complete Oracle and SQL
> novice.  The little that I've learned has come from SQL Visual
> Quickstart Guide and from hacking queries that I've stolen from Crystal
> Reports.
>
> 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. Received on Mon Jun 16 2008 - 13:47:30 CDT