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

Home » RDBMS Server » Server Administration » ORA-00933: SQL command not properly ended

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

ORA-00933: SQL command not properly ended [message #51773]

Wed, 12 June 2002 19:58

Pavithra
Messages: 2
Registered: June 2002

Junior Member

Hi ,

While executing the following SQL Query i am getting
ORA-00933: SQL command not properly ended
Error . How to Solve this ?

EXEC SQL SELECT COUNT(*) INTO :cnt FROM A WHERE RegTime < TO_DATE ( :b , 'YYYY/MM/DD HH24:MI:SS' ) ;

OS - Solaris
Oracle Version - Oracle8i
Pro*c compiler

regards,
Pavithra

Report message to a moderator

Re: ORA-00933: SQL command not properly ended [message #51833 is a reply to message #51773]

Sun, 16 June 2002 12:21

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

i beleive (im no pro*c guy)
u must not give colons ':" before placeholders.

try something like this

EXEC SQL SELECT ENAME, DEPTNO
INTO db_ename, db_deptno
FROM EMP
WHERE EMPNO = 7369;

Report message to a moderator

Previous Topic:	Oracle8
Next Topic:	peculiar problems in installation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 20:26:34 CDT 2024