Hi,
I a, trying to create a procedure which has a number of cursors, no inputs and no outputs. All it does is populate a table. On trying to compile it I get an error message saying that a table cannot be found within one of the cursors.
I have created a public synonym for the table and required priviledges.
For some reason, the pl/sql works fine, and the table is found, when its is within an anonymous block but once you wrap a procedure or function header around it, it can no longer find that table.
I a, trying to create a procedure which has a number of cursors, no inputs and no outputs. All it does is populate a table. On trying to compile it I get an error message saying that a table cannot be found within one of the cursors.
I have created a public synonym for the table and required priviledges.
For some reason, the pl/sql works fine, and the table is found, when its is within an anonymous block but once you wrap a procedure or function header around it, it can no longer find that table.