ORA-00933: SQL command not properly ended in Dynamic SQL
771549Jul 6 2011 — edited Jul 6 2011Hi all
I have a problem with dynamic SQL.
At run time I am building a query in a procedure to insert records into a table.
When I am running that procedure this error is thrown
ORA-00933: SQL command not properly ended
I have debugged the procedure and stored the dynamically build-ed query into a temp table.
When I checked the query it is syntactically fine. Every bracket or comma's etc are correct.
Even that query is running properly when I am running in toad.
I could not under stand why it is throwing an error.. where is wrong???
Can any one help me????
Edited by: maddyd2k on Jul 5, 2011 10:41 PM