Invoking a Java Stored Procedure using PL/SQL

Use a CALL statement in the trigger body clause of a PL/SQL statement to invoke a stored procedure, and pass arguments to it.

The CALL statement's arguments can be:

Literal values.
SQL expressions, but not bind variables.
Column references, qualified by correlation names.

Correlation names are prefixes to column references. Use these names to qualify whether the reference applies to the existing column value of the row being processed by the trigger or the value being written by the triggering event:

OLD refers to the the value of the column prior to the triggering operation.
NEW refers to the value being assigned to the column by the triggering operation. It is possible for the trigger body to redefine this value before the triggering operation occurs.

An example of a complete trigger definition:




  CREATE TRIGGER check_salary



  BEFORE UPDATE OF salary ON employee



  CALL salaryCheck(:new.job, :old.salary, :new.salary, :old.employeeID)