Error handling routines....

From: Miggins <mtproc_at_yahoo.co.uk>
Date: 27 Feb 2006 02:57:45 -0800
Message-ID: <1141037864.996328.161400_at_e56g2000cwe.googlegroups.com>



Each,

Have started working on an application which is a couple of years old. Has a 9i backend and currently 6i front end but will be moving to 9i or higher.

[Quoted] It has no built in error handling so am wanting to introduce this without causing too much disruption. Am not wanting to have to change all the calling parameters to the packages.

Am considering creating an error package with private variables to hold any errors raised and using a function which can be called from the client to check for any errors after calls to the server. What do people think about this approach?

[Quoted] Am thinking this would be OK for the user facing part of the app but for batch jobs would need a different approach like storing details away in an error log table.

Any pointers and clues as to what way i should be going?

Thanks In Advance Received on Mon Feb 27 2006 - 11:57:45 CET

Original text of this message