In a database application (oracle) do we need write our own exception classess?

[bnathvbdotnet]

Does VB.net provide enough exceptions so that we don't need to write our own exception classess ?

If vb.net doesn't provide exceptions related to the database, how can we write our own exceptions?

thank you

[VBCrazyCoder]

.NET has SQLExceptions that handle SQL exceptions thrown by your program, you just have to handle them. Depending on the size and detail of your application, you might want to think about creating your own Exception that inherits from Application Exception so you can customize to the hearts content.

Also, I think MS has an application block for exception handling that you might want to look at on their website.

[VBCrazyCoder]

Oh, didn't see the (Oracle) - don't use it so not sure, but you could always create your own anyway, like I said.

[Crunch]

In .NET Framework 1.1/VS 2003, there is an OracleClient namespace that contains an OracleException class:
ms-help://MS.VSCC.2003/MS.MSDNQTR.2003FEB.1033/cpref/html/frlrfsystemdataoracleclientoracleexceptionclasstopic.htm
"The exception that is generated when a warning or error is returned by an Oracle database or the .NET Framework Data Provider for Oracle. This class cannot be inherited."

[bnathvbdotnet]

Thank you guys.