Procedure references (PL/SQL)

Invocation references to PL/SQL procedures within PL/SQL contexts can be compiled by the Db2® data server.

A valid PL/SQL procedure reference consists of the procedure name followed by its parameters, if any.

Syntax

Read syntax diagramSkip visual syntax diagramprocedure-name(,parameter-value)

Description

procedure-name
Specifies an identifier for the procedure.
parameter-value
Specifies a parameter value. If no parameters are to be passed, the procedure can be called either with or without parentheses.

Example

The following example shows how to call a PL/SQL procedure within a PL/SQL context:
BEGIN
    simple_procedure;
END;

After a PL/SQL procedure has been created in a Db2 database, it can also be called using the CALL statement, which is supported inDb2 SQL contexts and applications using supported Db2 application programming interfaces.