SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-20004 when i tried to execute

chijarApr 7 2008 — edited Apr 9 2008

Dear all.
oracle st edition 10g r2

Three days ago, a friend that i work with me said that some procedures not executing and it shows ORA-20004 error without any error description.
The user have the execute privilege in each procedure although this is the owner of that procedures.
I had export and import, recreate de procedures, and with the last choice i had grant dba role to user but ... nothing =(

Only with SYS user i can execute this procedures.

Please help me !!!!
thabnks a lot

Locked Post

New comments cannot be posted to this locked post.

Locked on May 7 2008

Added on Apr 7 2008

3 comments

9,903 views