imported>Pavel: example

2010-02-18T12:42:49Z

example

Nová stránka

===Příkaz SIGNAL===
Signal an exception condition. Typ of condition is specified by SQLSTATE value. SQLState class (first two chars from SQLSTATE string) specifies sense of signal:

{| {{prettytable}}
|-
| Class|| Level
|-
| 00 || success
|-
| 01 || info
|-
| 02 || warning
|-
| xx || error
|}

SQLSTATE is one from some signal attributies. Others attributies are: message_text, pg_message_hint and pg_message_detail. All unhandled signals are emited to outer block. Unhandled error signals stop statement execution. Isn't possible trap class '00' signals. Explicitly unhandled signals of '01' and '02' class are handled by implicit empty warning procedure handler. This handler can be redefined (explicit NOT FOUND handler).

''Syntaxe''
<pre>
SIGNAL (SQLSTATE [VALUE] 'xxxxx'|condition)
[SET (message_text|hint|detail) '=' string [, ...]]

RESIGNAL [(SQLSTATE [VALUE] 'xxxxx'|condition)]
[SET (message_text|hint|detail) '=' string [, ...]]
</pre>
<pre>
SIGNAL SQLSTATE '22222' SET message_text = 'some message text', message_detail = 'detailed description';
</pre>

With RESIGNAL statement we can resignal modified trapped signal. This statement can be only in body of exception handler.

Emmiting signals - Historie editací

imported>Pavel: example