Ora-06508 pl/sql could not find program unit being called sys.dbms_cube_exp

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 the procedure or program was compiled, but contained errors. If using the OWB Oracle warehouse builder , a tool for managing and integrating data, in addition to other SQL operations, you can trigger the ORA error when one of the individual units within the program has not been appropriately compiled.

In order to correct this error , the user needs to check all programs referenced in an action. This will also included all package bodies, making sure the programs exist in full and are compatible with the action. You can run a query to discover any invalid objects or procedures that look like the following: select.

In the event that the user finds that the procedure has been dropped, trying to re-create the stored procedure can provide a simple fix. Additionally, if the stored procedure was compiled with errors, the user can correct the errors and proceed accordingly.

In some rare instances, the user may receive an ORA error and, when the user ends the current session and opens a new session, the error will disappear. Typically this error will be accompanied in a stack with several other errors such as the ORA and ORA, which reveal that existing states of packages have been discarded. The program may have been dropped or incompatibly modified, or have compiled with errors.

Action: C heck that all referenced programs, including their package bodies, exist and are compatible. An attempt was made to call a stored program that could not be found. 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. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams?

Collectives on Stack Overflow. Learn more. Asked 8 years, 3 months ago. Active 1 year ago. Viewed k times. I am using oracle 10g and toad I am trying to call an api from an anonymous block. Improve this question.

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. Add a comment. Active Oldest Votes. I suspect you're only reporting the last error in a stack like this: ORA existing state of packages has been discarded ORA existing state of package body "schema.

Improve this answer. Alex Poole Alex Poole k 9 9 gold badges silver badges bronze badges. Totally agree with you. I could care into the imaginary numbers about that.