ORA-06508: PL/SQL: could not find program unit being called

by

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, stateful package is recompiled (either
explicitly, with the “ALTER PACKAGE Statement”, or implicitly), the
next invocation of a subprogram in the package causes Oracle Database
to discard the existing package state and raise the exception
ORA-04068.

After PL/SQL raises the exception, a reference to the package causes
Oracle Database to re-instantiate the package, which re-initializes
it…

You can’t avoid this if your package has state. I think it’s fairly rare to really need a package to be stateful though, so you should revisit anything you have declared in the package, but outside a function or procedure, to see if it’s really needed at that level. Since you’re on 10g though, that includes constants, not just variables and cursors.

But the last paragraph from the quoted documentation means that the next time you reference the package in the same session, you won’t get the error and it will work as normal (until you recompile again).

More Related Contents:

  1. Place to store PL/SQL block [closed]
  2. ANYONE CAN TELL ME THAT WHY THIS CODE IS GIVING ME AN ERROR OF TABLE OT CLUSTER KEY WORD IS MISSING? [closed]
  3. Get counts of all tables in a schema
  4. Printing the value of a variable in SQL Developer
  5. PL/SQL – Use “List” Variable in Where In Clause
  6. Passing an array of data as an input parameter to an Oracle procedure
  7. Convert comma separated string to array in PL/SQL
  8. UTL_FILE.FOPEN() procedure not accepting path for directory?
  9. Oracle stored procedure with parameters for IN clause
  10. PL/SQL ORA-01422: exact fetch returns more than requested number of rows
  11. Split function in oracle to comma separated values with automatic sequence
  12. check if “it’s a number” function in Oracle
  13. How to return a resultset / cursor from a Oracle PL/SQL anonymous block that executes Dynamic SQL?
  14. How to send email using Oracle 10 g Forms
  15. SQL*Plus how to accept text variable from prompt?
  16. SQL Fiddle Output Error
  17. oracle PL/SQL how to calculate range ip for IPv6 cidr
  18. if (select count(column) from table) > 0 then
  19. Can We use threading in PL/SQL?
  20. Why cannot I use bind variables in DDL/SCL statements in dynamic SQL?
  21. Trying to export a Oracle via PL/SQL gives a date of 0000-00-00
  22. Oracle: how to INSERT if a row doesn’t exist
  23. Functions vs procedures in Oracle
  24. How to see refcursor result/output in Oracle SQL Developer? [duplicate]
  25. Reading clob line by line with pl\sql
  26. Why cannot I create triggers on objects owned by SYS?
  27. No more data to read from socket
  28. automating rollback script oracle
  29. How do I get column datatype in Oracle with PL-SQL with low privileges?
  30. Escaping single quote in PLSQL

Leave a Comment