Re: ORA-00911 error and COMMIT

In article <CATmaslin-F97F75.11134616062008_at_nntp.msstate.edu>, William Maslin <CATmaslin_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;
Are you executing these commands in SQL*Plus? Received on Tue Jun 17 2008 - 10:20:55 CDT