text, the following select statement throws:ORA-00904: "TEXT": invalid identifier select text from dual;
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;
select text.greeting from dual;
drop package text;