Re: after serverrror on database trigger

Jon wrote:

> system event trigger: after server error: i like to know if it possible to
> retrieve TEXT error and not only its code (server_error(1)) in a after
> server_error trigger. Thanks

Look at the demo at the bottom of the page at: http://www.psoug.org/reference/system_trigger.html

Specifically: "IF (IS_SERVERERROR(1017)) THEN"

HTH

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)