ecode

The error number associated with the exception condition.

errMsg

The error message associated with the exception condition.

In this example, the DhSQLException constructor creates an exception object called excep and then throws the excep object under all conditions:

CREATE PROCEDURE sp1_02()
BEGIN
     // raising exception 
     DhSQLException excep = new DhSQLException(666,new String
          ("Entered the tst02 procedure"));
     if (true)
     throw excep;
END