How to raise an exception in an HSQLDB procedure or function

Question

What I want to do is just throw an exception in HSQL 2.0.

As in Oracle, we can use: .... EXCEPTION WHEN OTHER THEN raise_application_error (XXX) ....

After reading the official HSQL documentation and trying what I can imagine, I still do not understand.

Is there anyone who can give a suggestion? Thanks!

+4

Villim Nov 11 '10 at 7:54

1 answer

fredt · Accepted Answer · 2010-11-11T09:45:55+0000

See the SIGNAL instruction in the Manual:

Example:

SIGNAL SQLSTATE '45000';

HSQLDB follows the SQL Standard PSM syntax for procedures and functions. DB2 also follows this syntax, so many DB2 examples can be used with HSQLDB.