Prepared Statement with Into
I am trying to create a dynamic query inside of a stored procedure that executes a query for each fetched row of a Cursor Loop. I am unable to make the dynamic query execute properly. Please someone help.. I am rather new to stored procedures and dynamic queries, however, I have been reading extensively on the subject.
When I call this procedure I receive "Undeclared variable: thispriority" ErrorNr. 1327
Here is my code...
Problem solved
Edited 1 time(s). Last edit at 10/29/2008 12:03PM by Richard Freisberg.
Subject
Views
Written By
Posted
Prepared Statement with Into
2396
October 28, 2008 02:02PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.