Procedure documentationExecuting Database Procedures Locate this document in the navigation structure


You execute the database procedure <dbproc_name> in SQLCLI in interactive mode (session mode).

Note Note

For information about the other options for executing database procedures in SQLCLI, see Executing Commands

End of the note.


You are logged on to the database.

More information: Logging On to a Database


call <dbproc_name> (<parameter_value_1>,<parameter_value_2>,..., <parameter_value_n>)

Enter the parameter values <parameter_value_n> as follows:

  • For input parameters, enter the values between inverted commas.

  • For output parameters, enter placeholders. You can use either a question mark ? as placeholder or the name of the placeholder using the following notation: :<placeholder_name>


SQL Tutorial, Database Procedures

More Information

SQL Reference Manual, Name of a Database Procedure (dbproc_name)