On Jun 16, 7:20=A0pm, William Maslin <CATmas...@[EMAIL PROTECTED]
> wrote:
> In article
> <bf92f83f-57a3-44d6-8897-2db3485d5...@[EMAIL PROTECTED]
>,
> =A0Ken Denny <k...@[EMAIL PROTECTED]
> wrote:
>
>
>
>
>
> > On Jun 16, 12:13=A0pm, William Maslin <CATmas...@[EMAIL PROTECTED]
>
wrote:=
> > > Hi,
>
> > > I'm been playing with using Filemaker Pro to generate and send sql
to =
an
> > > Oracle 10g database. =A0The following works fine:
>
> > > UPDATE BEVIS DL TEST RESULTS ENTRY
>
> > > SET BEVIS DL TEST RESULTS ENTRY.RESULT VALUE =3D 'A section of liver
i=
s
> > > examined microscopically. '
>
> > > WHERE BEVIS DL TEST RESULTS ENTRY.RESULT NAME =3D 'HISTOPATHOLOGY'
AND=
>
> > > BEVIS DL TEST RESULTS ENTRY.ACCESSION ID =3D '30257' AND
>
> > > BEVIS DL TEST RESULTS ENTRY.TEST CODE =3D '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 =3D 'A section of liver
i=
s
> > > examined microscopically. '
>
> > > WHERE BEVIS DL TEST RESULTS ENTRY.RESULT NAME =3D 'HISTOPATHOLOGY'
AND=
>
> > > BEVIS DL TEST RESULTS ENTRY.ACCESSION ID =3D '30257' AND
>
> > > BEVIS DL TEST RESULTS ENTRY.TEST CODE =3D '6005';
>
> > > COMMIT;
>
> > > These statements are generated in Filemaker "calculation" fields in
> > > which text and field values are concatenated to produce statements
lik=
e
> > > those above. =A0Please understand admit that I'm a complete Oracle
and=
SQL
> > > novice. =A0The little that I've learned has come from SQL Visual
> > > Quickstart Guide and from hacking queries that I've stolen from
Crysta=
l
> > > Re****ts.
>
> > > 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.
>
> I tried your suggestion and now I'm getting an ORA-06550 error: line 1
> column 6:
> PLS-00103: Encountered the symbol ";" when expecting the following:
> begin case, declare, exit, goto... (etc.)
>
> There's something about one of those semicolons that Oracle doesn't
> like. =A0I think that the semicolon is the problem with the ORA-00911
> error, too.
>
> Thanks for your help!
Don't put a semicolon after "BEGIN"
|
