Re: ORA-00911 error and COMMIT

In article <CATmaslin-F97F75.11134616062008@[EMAIL PROTECTED]
>, William
Maslin <CATmaslin@[EMAIL PROTECTED]
> 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?