Hello everybody,

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.

"CenturionX" <darwinbaldrich (AT) gmail (DOT) com> a écrit dans le message de news:
2f3f6e57-3cf3-4821-b4b7-e15f42193fe4...oglegroups.com...
Hello everybody,

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.

--------------------------------------------

http://asktom.oracle.com/tkyte/Misc/...rocedures.html

Regards
Michel

"CenturionX" <darwinbaldrich (AT) gmail (DOT) com> a écrit dans le message de news:
2f3f6e57-3cf3-4821-b4b7-e15f42193fe4...oglegroups.com...
Hello everybody,

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.

--------------------------------------------

http://asktom.oracle.com/tkyte/Misc/...rocedures.html

Regards
Michel

"CenturionX" <darwinbaldrich (AT) gmail (DOT) com> a écrit dans le message de news:
2f3f6e57-3cf3-4821-b4b7-e15f42193fe4...oglegroups.com...
Hello everybody,

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.

--------------------------------------------

http://asktom.oracle.com/tkyte/Misc/...rocedures.html

Regards
Michel

"CenturionX" <darwinbaldrich (AT) gmail (DOT) com> a écrit dans le message de news:
2f3f6e57-3cf3-4821-b4b7-e15f42193fe4...oglegroups.com...
Hello everybody,

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.

--------------------------------------------

http://asktom.oracle.com/tkyte/Misc/...rocedures.html

Regards
Michel

Thanks Michel,

Very useful.

Thanks Michel,

Very useful.

Thanks Michel,

Very useful.

Thanks Michel,

Very useful.