Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Understanding Pragma Init Exception and when others then exception ..

TinaJun 30 2014 — edited Jun 30 2014

Hi Gurus,

     I understand that using pragma init exception, allows you to associate user defined error message with valid plsql error code.

     But cant that be handled using when others then exception?Using sqlerrm and sqlerrcode, we can display those error messages and log them in.

     Could you please help me understand this?

Thanks
This post has been answered by unknown-7404 on Jun 30 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 28 2014
Added on Jun 30 2014
1 comment
698 views