Database Procedure Proxies

 

 

How do database procedure proxies work?

 

 

Database procedure proxies are a new type of ABAP dictionary object introduced with ABAP 7.40. They represent, inside the ABAP system, a database procedure that exists outside and independent of an ABAP system.

 

They have import and export parameters that are mapped to the parameters of the procedure.

 

A database procedure proxy allows you to call the database procedure it represents without using Native SQL. A new ABAP statement CALL DATABASE PROCEDURE is introduced for this purpose.

 

Database Procedure proxies in ADT

 

 

To create a database procedure proxy, you must use ADT. Database procedure proxies are not supported by the ABAP workbench.

 

In the ABAP project, open the context menu and choose NEW ->Other or New -> Other ABAP Repository Object. Open the Dictionary folder and select Database Procedure proxy. Specify the following: -

• The ABAP Package to which the proxy is to belong
• The ABAP name of the database procedure proxy and its description
• The name of an ABAP OO interface to be created. This interface holds the definition of the database procedure proxy parameters with their types, mapped to ABAP Dictionary types.
• The full name, including the SAP HANA content package name, of the database procedure for which a proxy is to be created.

 

 

Calling Database Procedure Proxies in ABAP

 

 

To call a stored procedure using a database procedure proxy, use the new statement CALL DATABASE PROCEDURE. The syntax is like function calls.