Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Stored Procedure Question

Stored Procedure Question

From: Matthew A. Givens <m3corps_at_earthlink.net>
Date: Tue, 25 Sep 2001 21:30:20 GMT
Message-ID: <MH6s7.13792$W83.1379671@newsread2.prod.itd.earthlink.net>

We're using Oracle stored procedures, and we use exception handlers so we can rollback in case of errors. The problem is that the stored procedure name and row number where the error occurred is always the exception handler of the uppermost stored procedure. Is there a way we can keep the ability to rollback on database error but have the location of the database error correctly reported?

Matthew A. Givens Received on Tue Sep 25 2001 - 16:30:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US