Skip to Main Content

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.Mar 12 2026

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.

This post has been answered by Christian Pitet. on Mar 14 2026
Jump to Answer
Comments
Post Details
Added on Mar 12 2026
7 comments
160 views