Pavel Stehule wrote:
> DECLARE excpt EXCEPTION [= 'SQLSTATE']
What would this default to? (i.e. if no '= SQLSTATE' is specified)
> Rules:
> o User can specify SQLSTATE only from class 'U1'
> o Default values for SQLSTATE usr excpt are from class 'U0'
Can you elaborate on what you mean?
> o Every exception's variable has unique SQLSTATE
> o User's exception or system's exception can be raised only with
> level EXCEPTION
It might be worth allowing a custom SQLSTATE to be specified for
non-exception RAISEs -- there are already WARNING SQLSTATE error codes
(see ERRCODE_WARNING).
-Neil
