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

Home -> Community -> Usenet -> c.d.o.misc -> Exception handler in pl/sql functions.

Exception handler in pl/sql functions.

From: Piero Stanchi <piero.stanchi_at_eu.pnu.com>
Date: Thu, 15 Oct 1998 20:08:29 -0700
Message-ID: <3626B8AD.538B@eu.pnu.com>


Hi everybody!
I would like to create an OTHERS exception handler that logs in an error log table the exceptions raised by a function body. The problem is that if the function is used in a select statement I get an ora 6571 error, because a function cannot execute insert, update or delete statements. I can do the logging for procedures but is there a way to do it for functions?
Thank you for any help.

--
Piero Stanchi - Pharmacia & Upjohn
Voice: +39 2 48384265 - Email: piero.stanchi_at_eu.pnu.com Received on Thu Oct 15 1998 - 22:08:29 CDT

Original text of this message

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