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!

To show the error

HuaMin ChenDec 23 2009 — edited Dec 24 2009

Hi,
how to show the errors using toad (new version, 9.1.0.62) against one 11g DB when compiling one procedure? it only says these
Warning: compiled but with compilation errors
Grant complete.
Grant complete.

I can't show that in this way as my login is restricted and I can't compile it through Sql plus

15:51:24 SQL> alter procedure abc.my_proc compile;
alter procedure abc.my_proc
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-20001: <<<< FE\my.login DataBase Object should be edit using TOAD ALTER - PROCEDURE >>>>
ORA-06512: at line 51

15:51:29 SQL> sho err
No errors.

any ideas?

Bst Rgds,
HuaMin

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 21 2010

Added on Dec 23 2009

3 comments

1,257 views