Skip to Main Content

Java Database Connectivity (JDBC)

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!

displaying full sql error text?

843854Aug 18 2004 — edited Aug 19 2004
I'm using getErrorCode() and getMessage() to display the following for an sql error

SQL error: SQLCODE: -551, SQLSTATE: 42501, SQLERRMC: auth-id ;operation;object-name


The SQLERRMC only has the auth-id, operation and object-name. How do I build this error message without doing it manually (detect 551 and build the error string)?

auth-id DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION operation ON OBJECT object-name
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 16 2004
Added on Aug 18 2004
3 comments
281 views