You can invoke a procedure from another SPL program by specifying the procedure name and parameters (if any) followed by a semicolon (;) in the following format:
name [ ([ parameters ]) ];
- name is the identifier of the procedure.
- parameters is a list of actual parameters.
The syntax for calling a procedure is the same as in the preceding syntax diagram when executing it with the EXEC statement in PSQL or PolarDB databases compatible with Oracle*Plus.
The following example describes how to call the procedure from an anonymous block:
BEGIN simple_procedure; END; That's all folks!