This typically happens when you try to load a unit which references another library unit that is non-existent or invalid. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Is so thereis an Oracle Applications board on metalink that may be of help.IMHO -- Mark D Powell -------Original Message-----From: oracle-l-bounce_at_freelists.orgOn Behalf OfA.Bahar_at_billing-components.comSent: Tuesday, June 14, 2005 8:27 AMTo: jkstill_at_gmail.comCc: oracle-l_at_freelists.orgSubject: Recovering data file from a fuzzy Windows Windows NT Service Control Manager. this contact form
It started very frequently after we upgraded database to 220.127.116.11 from 18.104.22.168. About Talent presentation Error: PLS-00801 Oracle ACE award Last books read What the customer want... The package in question is not a standard Oracle package so those items should have been part of your post. Can you please let us know what OBJECT TYPE is V_STUB?
This typically happens when you try toload a unit which references another library unit that isnon-existent or invalid.Action: Provide the needed library unit.But much beyond that no one here can do Nor did you identify if the package was home grown or part of a vendor product. Error report: ORA-06550: line 0, column 0: PLS-00907: cannot load library unit CLT.CHARGE (referenced by CLT.CALCINFACE) ORA-06550: line 7, column 1: PL/SQL: Statement ignored 06550. 00000 - "line %s, column %s:\n%s"
Checking the manuals and Metalink are first steps. Covered by US Patent. Please also read http://www.catb.org/~esr/faqs/smart-questions.html Jared On 6/13/05, A.Bahar_at_billing-components.com wrote: -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-l Jared Still at Jun 13, 2005 at 3:39 pm Pls-00907 Cannot Load Library Unit 12c I sincerly hope that you will avoid such tone in future as most of list members are very senior in experience and very valued due to their contributions towards this list
Join Now For immediate help use Live now! Ora-06550 Line 0 Column 0 Pls-00907 Cannot Load Library Unit Without seeing your script, without knowing what version of Oracle you are running and on what platform, it is hard for us to diagnose your problem. I would also advise against talking about "the very optimal way", unless yo= u're applying for the job of group's messiah, which Mladen Gogala at Jun 14, 2005 at 9:01 am A simple check of the error messages manual would have provided the following: Error: PLS-907 Text: cannot load library unit %s (referenced by %s) ------------------------------------------------------------------------ --- Cause: PL/SQL is unable to
Thank you.--http://www.freelists.org/webpage/oracle-l reply | permalink Goulet, Dick I'm afraid I agree with Rafiq. Pls-00907 Cannot Load Library Unit 11g Login. Try to understand what is requested . In the package code, package =3Dreferences itself .When I tried to compile, I receive following error. =20 Do you have any idea. =20 Rgds.Arslan. =20=20 SQL> alter package CUS$CUST_PRODS_AND_SVCS compile body;
The advise of some members (some of them are Authors) of this list is invaluable. Jared used to be list owner and he has the utmost respect=of the most=20people on this list. Pls-00907 Cannot Load Library Unit Oracle If you don't understand, If you =don't want to understand just delete that email and don't think anymore ab=out it . Pls-00907 Solution This is the very optimal way for thepeople like you.=20-----Original Message-----From: Jared StillSent: Monday, June 13, 2005 8:51 PMTo: Bahar, ArslanCc: oracle-l_at_freelists.orgSubject: Re: PLS-00907 : cannot load library unitAside from failing
Checking the manualsand Metalink are first steps. weblink Connect with top rated Experts 21 Experts available now in Live! doing absolutely nothing) it ran successfully. If you don't understand, If you don't want to understand just delete that email and don't think anymore about it . Cannot Load Library Unit String (referenced By String)
I, for one, ignored your question for precisely the re= asons mentioned=20 in Jared's email. When I have again restarted the step (after 2-3 hrs. This is the very optimal way for the people like you.Was this intended for Jared? navigate here The package in question is not astandard Oracle package so those items should have been part of yourpost.
You jumped to conclusion too soon. Ora-06553 Pls-907 Cannot Load Library Unit Jared's advise was totally correct as the requester did not try even on google( a free source) or metalink or even did not give basic info about database or that package. This is the very optimal way for the people like you.-----Original Message-----From: Jared StillSent: Monday, June 13, 2005 8:51 PMTo: Bahar, ArslanCc: oracle-l_at_freelists.orgSubject: Re: PLS-00907 : cannot load library unitAside from
To my knowledge, Jared never insulted anyone.....you owe him apology. It has happened 2-3 times recently, past 3 years this procedure was working fine. Let us know how you go with via a review. Cannot Load Library Unit (referenced By ) Drop and Recreatethe DBLinkFlush shared_poolCompile object specCompile object body Appreciate for your help in advance.
Given the age of the topic, i assume it is resolved satisfactorily 0 Featured Post Courses: Start Training Online With Pros, Today Promoted by Experts Exchange Brush up on the basics You could try that if its possible in your environment. This is the very optimal way for thepeople like you.-----Original Message-----From: Jared StillSent: Monday, June 13, 2005 8:51 PMTo: Bahar, ArslanCc: oracle-l_at_freelists.orgSubject: Re: PLS-00907 : cannot load library unitAside from failing his comment is here if you would like to post the actual code, the version ofOracle and the platform you are running on, perhaps one of us couldhelp you resolve your problem.On 6/14/05, A.Bahar_at_billing-components.comwrote:Please before
Try to understan=d what is requested .=20If you don't understand, If you don't want to understand just delete th=at email and don't think=20anymore about it .