Re: ORA-00933: SQL command not properly ended

Not disputing your word.

I looked and a table like 'v_$reserved_words' does not exist.

Must be something wrong, but I can't figure out what

Mike

Daniel Morgan wrote:

> Michael Hill wrote:
>
> > This is a query from a coldfusion script. When I put the sql in the sql
> > console it executes fine.
> >
> > Are you thinking it has some reserved words?
> >
> > The other queries in the coldfusion queries don't have semi-colons....
> >
> > Mike
> > "Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message
> > news:3F4BF737.8B59ABC2_at_exxesolutions.com...
> > > Michael Hill wrote:
> > >
> > > > I'm getting an oracle error when I attempt to update the datbase with
> > > > this sql the results from coldfusion:
> > > >
> > > > sql:
> > > >
> > > > UPDATE pim.LI_ACCESS SET NAME='John Gnagy', ROLE='User',
> > > > NT_USERID='gnagy', NT_DOMAIN='HHHHHH', STATUS='A' WHERE ACCESS_ID='330'
> > > >
> > > > error:
> > > > ORA-00933: SQL command not properly ended
> > > >
> > > > Look fine to me....
> > > >
> > > > Mike
> > >
> > > Not to me!
> > >
> > > Try this query:
> > >
> > > SELECT keyword
> > > FROM v_$reserved_words
> > > WHERE keyword LIKE 'NA%';
> > >
> > > SELECT keyword
> > > FROM v_$reserved_words
> > > WHERE keyword LIKE 'ROL%';
> > >
> > > and where's your semi-colon?
> > >
> > > --
> > > Daniel Morgan
> > > http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> > > http://www.outreach.washington.edu/extinfo/certprog/aoa/aoa_main.asp
> > > damorgan_at_x.washington.edu
> > > (replace 'x' with a 'u' to reply)
> > >
> > >
>
> SQL*Plus is not ColdFusion. ColdFusion is adding the semi-colons when it passes
> through the queries or they would never work.
>
> And I'm not "thinking" you are using reserved words. I know you are. That was
> 99% of the point of my response. Doing so is an act guaranteed to cause
> problems in any language with any software.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> http://www.outreach.washington.edu/extinfo/certprog/aoa/aoa_main.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
Received on Wed Aug 27 2003 - 13:01:03 CDT