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.

Prerequisites

You are logged on to the database.

More information: Logging On to a Database

Procedure

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>

Example

SQL Tutorial, Database Procedures

More Information

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