Re: Stored Procedure Error Traps

Steve Levy wrote: > > I am looking for some example of stored procedure error traps. > > Thanks. We trap all errors returned by the database server via an on execption and then propagate the error ba k to the caller. The exception handler is very simple in this case: --- Error handler on exception set sqlstat, sqlisam, sqltext return sqlstat, sqlisam, sqltext, procname; end exception; You can, of course, take any kind of corrective action you want within the exception handler. -- Carol Davies cdavies@csc.com