SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Package body not found even already exists

Christian Pitet.43 hours ago

Hi,

Under Oracle 23.i under Oracle APEX 24, I have a script beginning with:

declare 
  l_blob blob; 

begin 
  l_blob := aop_plsql_only_pkg.make_aop_request( etc…

But when I run it I get this error message:

ORA-04067: Package body "WKSP_LESPIEDSBOTS.AOP_PLSQL_ONLY_PKG" does not exist - not executed. ORA-06508: PL/SQL: Program unit named: "WKSP_LESPIEDSBOTS.AOP_PLSQL_ONLY_PKG" not found. ORA-06512: at line 4

But this package does exists in my workspace “create or replace package aop_plsql_only_pkg”. It is compiled without errors.

I checked the name of my workspace and it is well “WKSP_LESPIEDSBOTS”.

Best regards.

Added 43 hours ago

#pl-sql

6 comments

88 views

1 mention