Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Exception handler in pl/sql functions.
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