Database Procedure Proxies for SQLScript Procedures
As well as the regular Native SQL options (such as the method
AMDP) used for calls of standalone
in the SAP HANA database and created in SAP HANA Studio or using Native SQL, the special statement
CALL DATABASE PROCEDURE is also available. This statement accesses the database procedure using a
proxy saved in ABAP Dictionary. The database procedure proxy maps the database types of the interface parameters of the database procedures to ABAP data types. A
database procedure interface
is generated for these data types. The calling ABAP program can reference the types of this global interface.
7.31 | 7.40 | 7.54
ABAP Managed Database Procedures (AMDP) offers an alternative way of managing and calling database procedures in ABAP. It is far easier to handle database procedures using AMDP than with the calls using database procedure proxies described here, which is why AMDP is recommended whenever the central database of the current AS ABAP is an SAP HANA database and no secondary database connection to another SAP HANA database is needed.