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.
Open the SQL editor.
More information: Entering and Executing SQL Statements
Execute the database procedure using the CALL statement.
More information: SQL Reference Manual, CALL Statement (call_dbproc_statement)
CALL hotel.avg_price (20005, :avg_price)
| AVG_PRICE | | ------------- | | 135.00 |
SQL Tutorial, Database Procedures