4. Accessing a DBMS Using SQL : SQL Syntax : Execute Procedure
 
Share this page                  
Execute Procedure
OpenAPI does not require any query text to execute a database procedure. The application provides the database procedure name, procedure owner, and procedure parameters as parameters to the query and sets the query type to IIAPI_QT_EXEC_PROCEDURE. A database procedure can be executed as a regular query with query type IIAPI_QT_QUERY using the non-dynamic syntax, but procedure return values and output parameters are not available.