CALL statements
- Last Updated: November 7, 2022
- 1 minute read
- DataDirect Connectors
- ODBC
- Autonomous Rest Connector 8.0
- Documentation
The CALL statement is used to call a procedure. Functions and procedures
can call procedures, even recursively. However, called procedures cannot return table values
when called from inside another function or procedure. Only functions can return table
values. Note that the top-level procedure can return values through the JDBC to the calling
application.
CALL <procedure_name> (IN | OUT | INOUT <variable_name>[, ...])
- procedure_name
- is the name of the procedure you want to call.
- IN
- specifies that the parameter is an input parameter.
- OUT
- specifies that the parameter is an output parameter.
- INOUT
- specifies that the parameter is an input and output parameter.
- variable_name
- is the name of the variable in the parameter.