Calling a procedure v16
You can invoke a procedure from another SPL program by specifying the procedure name followed by any parameters and a semicolon:
name is the identifier of the procedure.
parameters is a list of parameters.
If there are no parameters to pass, you can call the procedure with an empty parameter list, or you can omit the parentheses.
The syntax for calling a procedure is the same as in the preceding syntax diagram when executing it with the
EXECcommand in PSQL or EDB*Plus. See SQL reference for information about the
This example calls the procedure from an anonymous block:
Each application has its own way of calling a procedure. For example, a Java application uses the application programming interface JDBC.