How to get back Error messages from stored procedure (OraDirect Mobile)

How to get back Error messages from stored procedure (OraDirect Mobile)

Postby tostinni » Fri 16 Dec 2005 19:49

I would like to use some of the stored procedure we have in our Oracle DB. I found the way to do this using OracleCommand, but I was wondering how was it possible to get back the error raised.

Stored procedure use the DBMS_ERROR_TEXT package to send RAISE_APPLICATION_ERROR message.
Currently these messages are intercepted by our Forms/Report application to notify the end user that something went wrong. Now I'm trying to develop a little app for PDA and I would use these procedures.
I still didn't make any test, but I would like to know if someone has experience with these events ?
Will they fire some errors that I can catch in a Try/Catch block ?

Thanks a lot for your answer.

PS : I would make some test during the WE, I keep you informed.
tostinni
 
Posts: 3
Joined: Thu 01 Dec 2005 18:46

Postby tostinni » Sun 18 Dec 2005 23:02

Ok, I just made some tests and it works great.

These kind of message (RAISE_APPLICATION_ERROR), just raise exception in VB code, so you can intercept the through a try/catch block ;)

Btw, for VB.NET programmers using stored procedure, I found a very usefull Oracle Stored Procedure Wrapper, it helps me a lot to speed up accessing these procedures in my code.
tostinni
 
Posts: 3
Joined: Thu 01 Dec 2005 18:46


Return to dotConnect for Oracle