OraFAQ Forum: Server Administration » Re: ORA-00933:SQL command not properly ended Runtime error

Home » RDBMS Server » Server Administration » Re: ORA-00933:SQL command not properly ended Runtime error - '-2147217900 (80040e14)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: ORA-00933:SQL command not properly ended Runtime error - '-2147217900 (80040e14) [message #51409]

Wed, 22 May 2002 03:13

Alex
Messages: 190
Registered: August 1999

Senior Member

The most likely cause is the data being inserted, maybe there is a quote or other character being inserted. Simple answer would be put some debug code in your VB and See whats being inserted

Report message to a moderator

Re: ORA-00933:SQL command not properly ended Runtime error - '-2147217900 (80040e14) [message #51431 is a reply to message #51409]

Wed, 22 May 2002 16:40

Parul
Messages: 6
Registered: May 2002

Junior Member

Thanks for writing back Alex !
I have found out with a bit of experimenting that it is the single quote ' that causes the error. Oracle assumes that as the end of the string, but in reality its not, and then it throws the error.

I have to work on some searching for strings and remove all ' . But I thought the varchar2 datatype would take evrything ?!

Report message to a moderator

Previous Topic:	oratab location
Next Topic:	Re: Oracle8i instance won't autostart on Windows 2000 with AD

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 16 18:58:20 CDT 2024