Oracle Notes

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;
Be Sociable, Share!

Tags:

This entry was posted on Friday, March 14th, 2008 at 10:35 am and is filed under database. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.