Language Guide

APPENDIX A
The Language at a Glance
Handlers 301
Handlers A
Handlers are collections of statements that are executed in response to
commands or error messages. Table A-6 summarizes handler definitions
and subroutine calls.
try try
[ statement ]...
on error ¬
[ errorMessageVariable]¬
[ number errorNumberVariable]¬
[ from offendingObjectVariable ]¬
[ partial result resultListVariable]¬
[ to expectedTypeVariable ]
[ global variable [, variable]...]
[ local variable [, variable]...]
[ statement ]...
end [ error | try ]
considering considering attribute [, attribute ... and attribute ] 
[ but ignoring attribute [, attribute ... and attribute ] ]
[ statement ]...
end considering
ignoring ignoring attribute [, attribute ... and attribute ] 
[ but considering attribute [, attribute ... and attribute ] ]
[ statement ]...
end ignoring
with timeout with timeout [ of ] integer second[s]
[ statement ]...
end [ timeout ]
with
transaction
with transaction [ session ]
[ statement ]...
end [ transaction ]
Table A-5 Control statements (continued)
Control
statement Syntax