Skip to Main Content

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!

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 7 2008
Added on Apr 7 2008
3 comments
10,006 views