Hi
I'm trying to use the Log4Plsql for the first time.
When compiling my test procedure - it says
that it isn't familiar with DBMS_PIPE.
From the documentation i learned that it's
necessary to grant the EXECUTE on DBMS_PIPE
to my user.
However, when i try to do that - the session
is stuck for some time and then the following
message apeears:
ORA-04021: timeout occurred while waiting to lock object SYS.DBMS_PIPE
It seems that someone locks the DBMS_PIPE ?
I'm in Oracle 9i RAC configuration (with Precise
tools running).
Any information is welcome.
Best regards,
Avi Vainshtein, DBA
aviva@pelephone.co.il
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi
I'm trying to use the Log4Plsql for the first time.
When compiling my test procedure - it says
that it isn't familiar with DBMS_PIPE.
From the documentation i learned that it's
necessary to grant the EXECUTE on DBMS_PIPE
to my user.
However, when i try to do that - the session
is stuck for some time and then the following
message apeears:
ORA-04021: timeout occurred while waiting to lock object SYS.DBMS_PIPE
It seems that someone locks the DBMS_PIPE ?
I'm in Oracle 9i RAC configuration (with Precise
tools running).
Any information is welcome.
Best regards,
Avi Vainshtein, DBA
aviva@pelephone.co.il