Lookup Oracle Error Messages

Description: Lookup Oracle error messages. Similar to unix “oerr” command.

SET serveroutput ON
SET veri off feed off
 
prompt Lookup Oracle error messages:
prompt
prompt Please enter error numbers AS negatives. E.g. -1
prompt
 
exec DBMS_OUTPUT.put_line('==> '||sqlerrm( &errno ) );
 
SET veri ON feed ON
undef errno

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.