06508 Oracle Error
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this ora-06508 oracle site About Us Learn more about Stack Overflow the company Business Learn more
Ora-06508 Error
about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss
Ora-06508 Pl/sql Could Not Find
Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ORA-06508: PL/SQL: could
Ora-06508 Could Not Find Program Unit Being Called
not find program unit being called up vote 7 down vote favorite 1 I am using oracle 10g and toad 11.5. I am trying to call an api from an anonymous block. If i recompile the api after adding dbms_output.put_line and then try to execute the anonymous block ,it shows error as "ORA-06508: PL/SQL: could not find program unit being called". However if i pl/sql could not find program unit being called end current session and open a new session , then the anonymous block will execute with out the error. Due to this issue, i am made to reconnect the session everytime i make a change to API. Can anyone help if this issue can be resolved by making any configurations in toad or database level. oracle plsql anonymous share|improve this question edited Jan 9 '14 at 6:02 user272735 5,84263464 asked Oct 15 '13 at 8:25 battech 3052312 2 Are you also getting something like 'existing package state had been discarded'? If so running it a second time in the same session ought to work. But that would suggest your package has some state, i.e. a variable declared in the package rather than in a procedure (and nothing to do with the dbms_output). –Alex Poole Oct 15 '13 at 9:45 add a comment| 3 Answers 3 active oldest votes up vote 15 down vote I suspect you're only reporting the last error in a stack like this: ORA-04068: existing state of packages has been discarded ORA-04061: existing state of package body "schema.package" has been invalidated ORA-04065: not executed, altered or dropped p
MySQL MariaDB PostgreSQL SQLite MS Office Excel Access Word Web Development HTML CSS Color ora-06508 forms Picker Languages C Language More ASCII Table Linux UNIX Java frm-40735 ora-06508 Clipart Techie Humor Advertisement Oracle Basics ALIASES AND AND & OR BETWEEN COMPARISON OPERATORS ora-06508 webutil DELETE DISTINCT EXISTS FROM GROUP BY HAVING IN INSERT INSERT ALL INTERSECT IS NOT NULL IS NULL JOIN LIKE MINUS NOT OR ORDER BY http://stackoverflow.com/questions/19376440/ora-06508-pl-sql-could-not-find-program-unit-being-called 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 https://www.techonthenet.com/oracle/errors/ora06508.php 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 http://www.orafaq.com/forum/t/155218/ 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 could not 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 could not find 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