Assert procedure : Utility Procedure « Stored Procedure Function « Oracle PL / SQL

1. Oracle PL / SQL
2. Stored Procedure Function
3. Utility Procedure

Assert procedure

 
SQL>
SQL>
SQL> SET ECHO ON
SQL>
SQL> CREATE OR REPLACE PROCEDURE ASSERT (
  2      condition IN BOOLEAN,
  3      message IN VARCHAR2) AS
  4  BEGIN
  5      IF NOT condition THEN
  6          RAISE_APPLICATION_ERROR (-20000,message);
  7      END IF;
  8  END;
  9  /

Procedure created.

SQL>
SQL>
SQL> --

 

Related examples in the same category