Re: ORA-00933: SQL command not properly ended

From: Michael Hill <hillmw_at_charter.net>
Date: Wed, 27 Aug 2003 02:30:45 -0500
Message-ID: <vko5tdasa4ik4a@corp.supernews.com>

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)
>
>
Received on Wed Aug 27 2003 - 02:30:45 CDT