Exceptions

From: <amerar_at_ci.chi.il.us>
Date: Tue, 09 Nov 1999 21:19:15 GMT
Message-ID: <80a34e$h97$1@nnrp1.deja.com>

Hello,

Can I have a 'catch all' exception for the entire PL/SQL procedure? So, if the procedure is executing and the code says:

v_fielda := TO_NUMBER(v_fieldb);

And this returns an error for some reason, I can trap the code and display it in a file. It there such an animal as having an 'error routine' or 'exception' for all errors that may occur within a procedure?

Thanks,

Arthur
amerar_at_ci.chi.il.us

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 09 1999 - 15:19:15 CST