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 Please enter error numbers AS negatives. E.g. -1
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.