SAP ADBC PROCEDURE ABEXA



Get Example source ABAP code based on a different SAP table
  



ABAP_ADBC - Stored Procedure
The example demonstrates the execution of a stored procedure using ADBC.

ABAP_SOURCE_CODE
DEMO CL_DEMO_ADBC_STORED_PROCEDURE

ABAP_DESCRIPTION
Using the method EXECUTE_PROCEDURE of the class CL_SQL_STATEMENT, the SQLScript procedure increase_price defined in the same class using the method EXECUTE_DDL is called. This increases all the flight prices in the table SFLIGHT in the current client by the value contained in the parameter incprice.
This procedure must be implemented specially for each database. The databases in this example are the SAP HANA database, MaxDB, and Oracle. This example class can only be executed for these databases.
The executable example AMDP, simple procedure call of an SQLScript procedure shows how the procedure can be managed and called as an ABAP Managed Database Procedure. A further executable example, specific to SAP HANA database, shows how the procedure is called using the statement CALL DATABASE PROCEDURE.