Skip to content

ABAP Keyword Documentation →  ABAP - Reference →  Processing External Data →  ABAP - Database Accesses →  ADBC - ABAP Database Connectivity →  CL_SQL_STATEMENT - Execution of SQL Statements 

Stored Procedures

Stored Procedures can be executed using the instance method

  • EXECUTE_PROCEDURE of the class CL_SQL_STATEMENT

The method has an obligatory input parameter PROC_NAME of type string, which must be passed the name of an existing stored procedure statement. Similar to in DML statements, it is possible to bind ABAP data objects as actual parameters on the formal parameter of the stored procedure using the method SET_PARAM. The kind of parameter must be specified using the additional parameter INOUT. Possible values are defined in the constants C_PARAM_IN, C_PARAM_OUT, and C_PARAM_INOUT of the CL_SQL_STATEMENT class. The value C_PARAM_IN is the default value. The sequence of the calls determines from left to right the assignment to the formal parameters.

Other versions: 7.31 | 7.40 | 7.54


Example

Refer to ADBC, Stored Procedure