Table cannot be found when in a Procedure. 1

[Kontact]

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.

 

[sem]

To refer to foreign objects from stored procedure you need explicit grant (not via role) on that object.

Regards, Dima

http://seminihin.narod.ru

 

[Kontact]

Sorry for the nievity, but what sort of grant are you referring to. My user already has Select, Update and Delete priviledges on the table.

Regards

 

[sem]

Your user probably does not have those grants. Just issue

GRANT SELECT, UPDATE, DELETE ON <TABLE> TO <USER>

and see what happens.

Regards, Dima

http://seminihin.narod.ru