Could Not Find Program Unit Being Called Oracle Error
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
could not find program unit being called ora-06512 ORA-06508: PL/SQL: could not find program unit being called tipsOra-06508 Forms
Oracle Error Tips by Stephanie F. The Oracle docs note this on the ora-06508 error: ORA-06508: PL/SQL: could not ora-06508 webutil find program unit being called. Cause: An attempt was made to call a stored program that could not be found. The program may have been dropped or incompatibly modified, or have compiled with errors. Action: Check frm-40735 ora-06508 that all referenced programs, including their package bodies, exist and are compatible. In Oracle warehouse builder (OWB) and other PL/SQL operations, you get the ORA-06508 error when one of the program units has not been properly compiled or it cannot be located (a problem with your $PATH environment variable). An attempt was made to call a stored program that could not be found. The program may have been dropped or incompatibly
Ora-06508 Unhandled Exception
modified, or have compiled with errors. Check that all referenced programs, including their package bodies, exist and are compatible. You can use this script to recompile any invalid objects. For full scripts, download the Oracle script collection. You can run this query to find invalid objects, which may cause the ORA-06508 error: select comp_id, comp_name, version, status, namespace, schema from dba_registry; Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals. Feel free to ask questions on our Oracle forum. Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications. Errata? Oracle technology is changing and we strive to update our BC Oracle support information. If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Just e-mail: and include the URL for the page. Burleson Consulting The Oracle of Database Support Oracle Performance Tuning Remote DBA Services Copyright © 1996 - 2016 All rights reserved by Burleson Oracle is the registered trade
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it ora-06508 forms 11g will not work correctly without it enabled. Please turn ora-04063 package body JavaScript back on and reload this page. Please enter a title. You can
When-custom-item-event Trigger Ora-06508
not post a blank message. Please type your message and try again. More discussions in General EBS Discussion All PlacesOracle ApplicationsE-Business SuiteE-Business http://www.dba-oracle.com/t_ora_06508_pl_sql_could_not_find_program_unit_being_called.htm Suite TechnologyGeneral EBS Discussion This discussion is archived 11 Replies Latest reply on Aug 26, 2010 7:29 AM by 609456 ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_GSM_ 609456 Aug 23, 2010 5:51 AM Hi All, We are following Export/Import Process https://community.oracle.com/thread/1120178 for Oracle Applications Release 11i Database Instances Using Oracle Database 10g Release 2 note: 362205.1 Source OS = AIX Target OS = RHEL 5 DB version = 10.2.0.4 At Section 5: Update the imported Applications Release 11i database instance Perform post-import steps outlined in the Interoperability documents At post-import step: Implement and run AutoConfig Completed the below tasks: Copied the appsutil.zip file to to new OS ORacle home Generated the Database Context File While Running adconfig get the error --------------------------------------------------------------- ADX Database Utility --------------------------------------------------------------- getConnectionUsingAppsJDBCConnector() --> APPS_JDBC_URL='null' Trying to get connection using SID based connect descriptor getConnection() --> sDbHost : ORADB sDbDomain : quest-global.com sDbPort : 1521 sDbSid : TST sDbUser : apps Trying to connect using SID... getConnectionUsingSID() --> JDBC URL: jdbc:oracle:thin:@ORADB.quest-global.com:1521:TST Connection obtained -------------------ADX Database Utility Finished-------
MySQL MariaDB PostgreSQL SQLite MS Office Excel Access Word Web Development HTML CSS Color https://www.techonthenet.com/oracle/errors/ora06508.php Picker Languages C Language More ASCII Table Linux UNIX Java http://www.orafaq.com/forum/t/155218/ Clipart Techie Humor Advertisement Oracle Basics ALIASES AND AND & OR BETWEEN COMPARISON OPERATORS DELETE DISTINCT EXISTS FROM GROUP BY HAVING IN INSERT INSERT ALL INTERSECT IS NOT NULL IS NULL JOIN LIKE MINUS NOT OR ORDER BY could not PIVOT REGEXP_LIKE SELECT SUBQUERY TRUNCATE UNION UNION ALL UPDATE WHERE Oracle Advanced Oracle Cursors Oracle Exception Handling Oracle Foreign Keys Oracle Loops/Conditionals Oracle Transactions Oracle Triggers String/Char Functions Numeric/Math Functions Date/Time Functions Conversion Functions Analytic Functions Advanced Functions Oracle / PLSQL: ORA-06508 Learn the cause and how could not find to resolve the ORA-06508 error message in Oracle. Description When you encounter an ORA-06508, the following error message will appear: ORA-06508: PL/SQL: could not find program unit being called Cause You tried to call a stored procedure, but the stored procedure could not be found. Resolution The option(s) to resolve this Oracle error are: Option #1 The stored procedure may have been dropped. Try re-creating the stored procedure. Option #2 The stored procedure may have compiled with errors. Try fixing the errors and re-compiling. Share this page: Advertisement Back to top Home | About Us | Contact Us | Testimonials | Donate While using this site, you agree to have read and accepted our Terms of Service and Privacy Policy. We use advertisements to support this website and fund the development of new content. Copyright © 2003-2016 TechOnTheNet.com. All rights reserved.
Show Polls :: Message Navigator E-mail to friend ORA-06508: PL/SQL: could not find program unit being called [message #443935] Thu, 18 February 2010 01:15 ahmadsaeed Messages: 24Registered: November 2009 Location: Lahore, Pakistan Junior Member Dear all, we are facing a problem, your suggestions and comments will be very helpful here. Actually what happens is that we are connected to oracle through forms 6i. suddenly we receive the error " ORA-06508: PL/SQL: could not find program unit being called " while doing some transaction. we have searched on net and meta link. they say that the package / procedure called has become invalid or recompilation has occurred and that is not compatible. Now we have monitored carefully that there are no changes what so ever has been made in the the package/ procedure. what could be the reason behind this. we have also checked the global variable issue. we use package level variables but declared in the package body only. (so these are not public) what you say ? Need your opinion. Thanks Ahmad Saeed Report message to a moderator Re: ORA-06508: PL/SQL: could not find program unit being called [message #443996 is a reply to message #443935] Thu, 18 February 2010 05:15 ramoradba Messages: 2454Registered: January 2009 Location: AndhraPradesh,Hyderabad,I... Senior Member Are you getting that error still? As oracle suggested at may happen when ever the object gets invalid statement due to teh dependent object re compilation or any error occured on that object or its dependent object. If it successfully compiled then you wont get that error.Didi you try to connect through that after some time? whats happend ? sriram Report message to a moderator Re: ORA-06508: PL/SQL: could not find program unit being called [message #444000 is a reply to message #443996] Thu, 18 February 2010 05:49 ahmadsaeed Messages: 24Registered: November 2009 Location: Lahore, Pakistan Junior Member Thanks dear, yes this is the problem, we re-login the problem is gone. Now why that object gets invalid even compiled all right (if changes were made). and if the object was invalid then why re-login solved the issue. The problem should only be occurring when trying to attempt a call first time, re-attempt should solve the issue without re-login. what do you say ? Report message to a moderator Re: ORA-06508: PL/SQL: could not find program unit being called [message #444002 is a reply to message #444000] Thu, 18 Febru