Calling a procedure v15

Suggest edits

You can invoke a procedure from another SPL program by specifying the procedure name followed by any parameters and a semicolon:

<name> [ ([ <parameters> ]) ];

Where:

name is the identifier of the procedure.

parameters is a list of parameters.

Note

  • 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 EXEC command in PSQL or EDB*Plus. See SQL reference for information about the EXEC command.

This example calls the procedure from an anonymous block:

BEGIN
   simple_procedure;
END;

That's all folks!
Note

Each application has its own way of calling a procedure. For example, a Java application uses the application programming interface JDBC.

← Prev

Creating a procedure

Next →

Deleting a procedure