This content has been marked as final. Show 1 reply
Welcome to the forum!
Your question isn't clear. Provide the specifics about your types, tables and procedure.
What is a 'Type table'? How is that table referenced?
One possibility is that there is a privilege missing.
In stored procedures priviliges to objects (e.g. to tables) need to be granted directly to the user and not thru a role.
So if the table is in the SCOTT schema and the user that owns the procedure is HR then HR needs to be granted privileges to the table directly
GRANT SELECT ON SCOTT.EMP TO HR;