Oracle Database Discussions

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!

PLS-00907: cannot load library unit

407048Mar 15 2005 — edited Mar 16 2005

I have a problem with a stored procedure that runs via cron to insert records into a large partitioned table. This was running fine until a week back it stopped working.
The error it mentioned during execution is

PLS-00907: cannot load library unit
MET.CLINICAL_DATA (referenced by MET.INSERT_CLINICAL_DATA)

MET is the owner of the CLINICAL_DATA table and the INSERT_CLINICAL_DATA procedure. This procedure is run by a user called MET_USER who has an execute privilege on MET's INSERT_CLINICAL_DATA and its tables.

So what might have caused this error. I did spend atleast 2 hours looking in the metalink and as those articles mentioned, I am neither using a database link here nor I am calling a remote procedure.

Any thoughts?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 13 2005

Added on Mar 15 2005

#general-database-discussions

4 comments

891 views