ORA-06553: PLS-:

Example

By default, there is no object named text, the following select statement throws:ORA-00904: "TEXT": invalid identifier

select
   text
from
   dual;

Create a PL/SQL package named text:

create package text as
   function greeting return varchar2;
end;
/

create package body text as
   function greeting return varchar2 as begin
       return 'Hello World!';
   end greeting;
end;
/

text is a package, not a procedure. Oracle throws ORA-06553: PLS-221: 'TEXT' is not a procedure or is undefined:

select
   text
from
   dual;

The following statement runs:

select
   text.greeting
from
   dual;

Cleaning up:

drop package text;

ORA-06553: PLS-:

Example

See also