06508 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 site About Us Learn more about Stack Overflow the company Business Learn more ora-06508 pl/sql could not find about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges ora-06508 forms Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each ora-06508 webutil other. Join them; it only takes a minute: Sign up ORA-06508: PL/SQL: could 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 ora-06508 unhandled exception 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 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
Ora-06508 Forms 11g
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 package body "schema.package" ORA-06508: PL/SQL: could not find program unit being called: "schema.package" If so, that's because your package is stateful: The values of the variables, constants, and cursors that a package declares (in either its specification or body) comprise its package state. If a PL/SQL package declares at least one variable, constant, or cursor, then the package is stateful; otherwise, it is stateless. When you recompile the state is lost: If the body of an instantiated, sta
Digital Records Management Enterprise Content Management Strategy Digital Asset Management Oracle Imaging & Process Management Web Content Management Oracle WebCenter Portal Enterprise Portal Support Enterprise
Could Not Find Program Unit Being Called Ora-06512
Portal Strategy Enterprise Portal Upgrade Oracle WebCenter Sites Sourcing Staffing frm-40735 ora-06508 & Recruiting Recruiting Managed Services Candidate Registration Technical Focus Client Opportunities Support Solutions Training Legacy when-custom-item-event trigger ora-06508 to Oracle WebCenter Oracle Documents Cloud Service Next Generation AP Automation & Dynamic Discounting Oracle WebCenter Contract Lifecycle Management (CLM) Search ORA-06508: could not find program http://stackoverflow.com/questions/19376440/ora-06508-pl-sql-could-not-find-program-unit-being-called unit being calledYou are here: Home / Resources / ORA-06508: could not find program unit being called ORA-06508 As a database manager delves further and further into their duties of constructing database materials for their company, several files and processes, both big and small, will start to seem like ancient history. https://www.tekstream.com/resources/ora-06508-could-not-find-program-unit-being-called/ Typically, this is fine as we create and store procedures just for that purpose; we want to be able to instantly recall past constructions and signal them at ease. However, there are times when we create and store information in a database that, over time, becomes either incompatible with newly designed additions or corrupted. We are then forced to correct these past mistakes and adapt them to current requirements. The ORA-06508 is an error indicative of this type of situation in which maintenance must be performed on a past design to ready it for the up-to-date database needs. The Problem The ORA-06508 is an error deriving from a program unit being called and not being found. What this means is that the user tried to call a procedure that was not available due to the procedure being dropped or modified in an incompatible manner. It can also occur when
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 http://www.orafaq.com/forum/t/155218/ 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 could not 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 could not find 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: