To consume the HANA procedure in ABAP we have to expose the HANA procedure by creating a Database Procedure Proxy in the ABAP Dictionary but the ADT allows you to create one only when the underlying database is SAP HANA.
Is it really not possible to consume SAP HANA Procedure when SAP HANA is used as a secondary Database ?
Looking at the ABAP statement CALL DATABASE PROCEDURE it does not see so as it has a keyword CONNECTION which connects the secondary Database, so it is possible.
How can the ABAP procedure proxy be created ?
Database procedure proxy in ABAP could be created using the Class CL_DBPROC_PROXY_FACTORY.
Once the ABAP Procedure proxy is created then the HANA procedure could be consumed using the ABAP statement CALL DATABASE PROCEDURE.