Procedure documentationExecuting Database Procedures Locate this document in the navigation structure

Prerequisites

  • You are logged on to the database as a database user.

  • You have the EXECUTE privilege for the database procedure.

    More information: SQL Reference Manual, Privileges: Overview

  • The database is in the ONLINE operational state.

Procedure

  1. Open the SQL editor.

    More information: Entering and Executing SQL Statements

  2. Execute the database procedure using the CALL statement.

    More information: SQL Reference Manual, CALL Statement (call_dbproc_statement)

Example

CALL hotel.avg_price (20005, :avg_price)

| AVG_PRICE | | ------------- | | 135.00 |

More Information

SQL Tutorial, Database Procedures