Re: ORA-00911 error and COMMIT

In article <7EQ5k.10084$mh5.279@[EMAIL PROTECTED]
>,
 spambait@[EMAIL PROTECTED]
 (Doug Miller) wrote:

> 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?

No, this is all done in Filemaker - which has the capability to send SQL 
to UPDATE or query, etc to Oracle (or other DBs).  Similar to MS Access 
but a little easier to work with.