Re: [SQL] calling EXECUTE on any exception

Oh...to bad...Thank you Michael! Did someone know if it can be acomplished in pypgsql? Thanks againg falks. Gerardo > On Fri, Jul 29, 2005 at 10:36:52AM -0300, [EMAIL PROTECTED] wrote: >> EXCEPTION >> WHEN OTHER THEN >> EXECUTE exception_handler(Exception_code) >> >> how do i get that error_

Re: [SQL] calling EXECUTE on any exception

On Fri, Jul 29, 2005 at 10:36:52AM -0300, [EMAIL PROTECTED] wrote: > EXCEPTION > WHEN OTHER THEN > EXECUTE exception_handler(Exception_code) > > how do i get that error_code (or code_name, whatever i can get) > generated in the something() function to be proccesed by the > exception_handler()

[SQL] calling EXECUTE on any exception

Hi all: I want to call some FUNCTION , let say exception_hanler(Exception_code) for any exception in plsql functions. I give some pseudo code to explain myself better: CREATE FUNCION something(...) returns ... AS ' ... EXCEPTION WHEN OTHER THEN EXECUTE exception_handler(Exception_code) ...