Re: ORA-00933: SQL command not properly ended

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)