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.
How to get back Error messages from stored procedure (OraDirect Mobile)
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.
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.