ERROR message;Error statement
An ERROR statement declares that the procedure has entered an error state and should abort.
This statement will also roll back the current transaction, if one exists.
Any valid expression can be specified after the ERROR keyword.
Usage
Example: Error statement
ERROR 'Invalid input value: ' || nvl(Acct.GetBalance.AcctID, 'null');An ERROR statement is equivalent to:
RAISE SQLEXCEPTION message;