OraFAQ Forum: Forms » unexpected error from EXEC_SQL:921ORA-00921:Unexpected end of sql command

Home » Developer & Programmer » Forms » unexpected error from EXEC_SQL:921ORA-00921:Unexpected end of sql command

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

unexpected error from EXEC_SQL:921ORA-00921:Unexpected end of sql command [message #494142]

Fri, 11 February 2011 08:57

piyarustagi
Messages: 38
Registered: January 2011

Member

EXEC_SQL.PARSE(CONNECTION_ID,CURSOR_NUMBER, 'SELECT count(*) FROM "Work"@PASS WHERE "PId" = (SELECT PId from cr_layout where L_NO =''' || :CT.L_NO || '''');

Gives this error -- unexpected error from EXEC_SQL:921ORA-00921:Unexpected end of sql command

I know it's related to the bracket at the end but I'm not able to correct it...plz. help

Report message to a moderator

Re: unexpected error from EXEC_SQL:921ORA-00921:Unexpected end of sql command [message #494145 is a reply to message #494142]

Fri, 11 February 2011 09:05

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Standard advise for debuggind dynamic sql:
Assign the dynamic sql string to a variable.
Output the variable somewhere (assign it to a datablock item if you're using forms).
Copy and paste the output sql statement into sqlplus and see what it makes of it.

Report message to a moderator

Re: unexpected error from EXEC_SQL:921ORA-00921:Unexpected end of sql command [message #494148 is a reply to message #494145]

Fri, 11 February 2011 09:25

piyarustagi
Messages: 38
Registered: January 2011

Member

true thanks

Report message to a moderator

Previous Topic:	Forms hanging when trying to commit or update
Next Topic:	Adding hours and minutes to time

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 16 13:05:46 CDT 2024