I have a VB front-end application that calls an Oracle stored
procedure in the back-end. My problem is that, in my VB front-end, the
connection object's error collection is never populated with the error
that occurred. Currently, I am getting a constraint error which I
would like to trap from VB and I cannot. I used to do this all the
time in SQL Server.

Any ideas?

Have you trap the exception withing the sp ?

If you have trapped the error within the stored procedure, it wont
return the error to ado.

--
hth
Hirantha
Please reply only to the newsgroups.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

On Tue, 05 Mar 2002 13:00:46 -0800, Hirantha Hettiarachchi

I am trapping the error within the stored procedure but I am also
raising the errors from the procedure in the EXCEPTION handler. It is
this error that I want to trap in the ADODB.Errors collection and I
cannot.