Customized errors from Oracle

  • Thread starter Thread starter Robert Scheer
  • Start date Start date
R

Robert Scheer

Hi.

I need to raise a customized error message from a stored procedure in
Oracle 8i and catch this error in my Try...Catches in VB.NET. Can
anyone point me to an article or something that teaches how to do it?
OTN site is terrible to find anything!!!

Thanks,
Robert Scheer
 
Although you complained about the OTN website, perhaps you want to re-read
their docs. Specifically, you should read the user-defined exceptions
section, in the PL/SQL manual's Error Handling section.

Then consider reading about the System.Data.Oracle.OracleException object,
and it's Code property- and implement everything into your exception
handling block.

Those two pieces (PL/SQL section and OracleException) object should do it!

-Thomas
 
Back
Top