Date: Mon, 22 Dec 2008 14:08:06 -0800 (PST)
Iím having trouble trying to run a procedure.
I have a query that retrieves information from a table X.
I run the query and it works fine.
When I put the same query in a cursor into a procedure it generates an error
PL/SQL: ORA-01031: insufficient privileges The user Iím using is created in one schema and the table I want to query is in another one.
I took care of put the schema prefix for the table. Please give a hand on this.
Thanks. Received on Mon Dec 22 2008 - 16:08:06 CST