EXECUTE PROCEDURE

After you create a procedure, you must run it using the EXECUTE PROCEDURE command for the actions in the procedure to occur. You can do this using the SQL interactive interface (nco_sql) or in a trigger or procedure.

Syntax

{ EXECUTE | CALL } [ PROCEDURE ] procedure_name
 [ ( expression,... ) | ( [ expression, expression,... ] ,... ) ];

Use procedure_name to specify the procedure to run.

Each of the expressions passed as actual parameters must resolve to an assignable value that matches the type of the parameter specified when the procedure was created.

Note: If you are passing an array parameter, the square brackets around the expression list, shown in bold type in the preceding syntax description, are not optional.

Example

To run the procedure described in CREATE PROCEDURE (external procedures), use the following call in a trigger:

execute send_email( critical.Node, critical.Severity, 'Netcool E-mail', 
'root@localhost', critical.Summary, 'localhost');