I'm CaLendarW Blog

Run shell in sqlplus:

host ls -l

or

!ls -l

Dummy Table Name: dual

Get user error message in oracle:

select * from user_errors;

or

show errors;

ERROR: PLS-00201: identifier ‘SYS.DBMS_PIPE’ must be declared
Connect to the SYS schema and issue the following command:

grant all on dbms_pipe to public;