ARTICLE
Stored Procedures
Stored procedures can be executed using the following instance
method of the class CL_SQL_STATEMENT
EXECUTE_PROCEDURE
The method has an mandatory input parameter PROC_NAME of type
string , which must be passed the name of an existing stored
procedure statement. In the same way as in
DML statements , it is possible to bind ABAP data objects as actual
parameters to the formal parameters of the stored procedure using
the method SET_PARAM . The type 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 class CL_SQL_STATEMENT . C_PARAM_IN
is the default value. The order of the calls determines the assignment
to the formal parameters from left to right.
Note
On the SAP HANA database , the
stored procedures are database
procedures written in SQLScript .
The more powerful statement CALL
DATABASE PROCEDURE is used to call these procedures.
Example
See ADBC, Stored Procedure
Documentation extract taken from SAP system, © Copyright SAP AG. All rights reserved