Re: ORA-00911 error and COMMIT

In article <7EQ5k.10084$mh5.279_at_nlpi067.nbdc.sbc.com>,  spambait_at_milmac.com (Doug Miller) wrote:

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

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. Received on Tue Jun 17 2008 - 11:08:27 CDT