Execute a stored procedure

In this example, we are using schema QA_J in TEST_TABLE1.

Table Schema


SAP HANA Table Schema

Stored Procedure

The following is a sample stored procedure:


SAP HANA Stored Procedure Definition

Configuration

In the Snap, we specify the schema, the stored procedure called, and supply a parameter to specify the ID. If we define $num as 1, then the NAME value of A is returned.


SAP HANA Stored Procedure Configuration