TRY statement
Wed, 03/04/2009 - 20:02 | 
hdanzl
Specify a TRY..CATCH block.
Syntax
|
TRY <protected statement block> <catch clause>... END |
<protected statement block> ::= <SQL statement list>
<catch clause> ::= CATCH error-condition [ <catch statement block> ]
<catch statement block> ::= <SQL statement list>
Usage
The TRY statement is used to protect a block of SQL statements, and handle some or all of the possible errors that might occur during the execution, gracefully in SQL code. The concept is similar to TRY statements found in many programming languages.
Notes
| ♦ | Several CATCH clauses may be specified, but at least one is required. |
| ♦ | A specific error-condition can be determined by evaluating the current error message using the ERROR_MESSAGE system function. |
| ♦ | The statement block of the first CATCH clause that evaluates to true is executed. |
| ♦ | If none of the CATCH clauses evaluates to true, then the current exception is raised. |
Examples
| 1) | The following example shows the TRY statement used to control an explicit transaction: |
START TRANSACTION;
TRY
// Execute some data-change statements here.
COMMIT;
CATCH POSITION( 'Unable to open table' IN ERROR_MESSAGE ) <> 0
ROLLBACK;
SIGNAL ERROR_MESSAGE;
END;
Conformance
|
NexusDB extensions |
- |
TRY statement |
Tags:
Questions? Problems?
- Interested to buy but something put you off?
- Can't find what you're looking for?
- Have a suggestion?
Let us know. If you're having trouble contacting us, please check here.
Site Updates
- Dec 4 2024 - 1:53pm
- Dec 4 2024 - 1:48pm
- Nov 19 2024 - 1:04pm
- Oct 17 2024 - 10:27am
- Jul 24 2024 - 1:22pm