Greetings - I have a oracle database that I've inherited that has error handling internal to the database triggers (pre-insert triggers). They issue errors with a
raise_application_error(-20001, 'This is an error');
This is all fine and good except that it produces an error in Access that looks like this:
ODBC --Insert on linked table 'blabla' failed.
[Oracle][ODBC][Ora]ORA-20001: This is an error
ORA-06512: at "trigger name" line 3
ORA-04088: error during execution of trigger "trigger name" (#20001)
My task has been to make this more friendly... I can isolate the Access part of the error with AccessError, but can't figure out a way to get the whole message... If I can get the whole message into a string I can parse it for the ORA-20001 substring, but my challenge is to get it into a string... Can anyone help?
raise_application_error(-20001, 'This is an error');
This is all fine and good except that it produces an error in Access that looks like this:
ODBC --Insert on linked table 'blabla' failed.
[Oracle][ODBC][Ora]ORA-20001: This is an error
ORA-06512: at "trigger name" line 3
ORA-04088: error during execution of trigger "trigger name" (#20001)
My task has been to make this more friendly... I can isolate the Access part of the error with AccessError, but can't figure out a way to get the whole message... If I can get the whole message into a string I can parse it for the ORA-20001 substring, but my challenge is to get it into a string... Can anyone help?
