Details
-
Technical task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
This statement is used to raise an application error, similar to SIGNAL in MariaDB
Oracle Docs: https://docs.oracle.com/cd/B28359_01/appdev.111/b28370/raise_statement.htm#LNPLS01337
Example:
IF SQLCODE = -30041 THEN |
SQLSTR := 'SELECT COUNT(*) FROM USER_TABLESPACES |
WHERE TABLESPACE_NAME = ''SSH_DATA'' AND CONTENTS = ''TEMPORARY'''; |
EXECUTE IMMEDIATE SQLSTR INTO TEMP_COUNT; |
IF TEMP_COUNT = 1 THEN RETURN; |
ELSE RAISE; |
END IF; |
ELSE |
RAISE;
|
END IF; |