Exception Handling with oracle stored procedure

Question

Hi All I want to Trap an Exception Raised by Oracle Stored Procedure in C#.Net code. I am using Microsoft's Oracle ADO.Net Provider. Thanx Avi

Andrzej Wegierski · Answer

Use Oracle procedure to return exception information without re-throwing exception: EXCEPTION WHEN ... THEN RETURN ... END; and next recognize exception kind in c#