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.
>>-procedure-name--+-------------------------------+----------->< | .-,-------------------. | | V | | '-(----+-----------------+-+--)-' '-parameter-value-'
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 in DB2 SQL contexts and applications using supported DB2 application programming interfaces.