Stored procedure parameter definition(Table Type Definition)

[Former Member]

Hi,

    I am looking for the definition of table types which are used as IN/OUT parameters of stored procedures. Basically i am able to get the procedures and their types in views but i didn't find any view which is stores table types of stored procedures.

   Is anybody aware of this?

Thanks,

Venkatesh

[thomas_jung · Accepted solution]

From a metadata standpoint table types are tables.  You can read their information from SYS.TABLES and SYS.TABLE_COLUMNS like any normal tables.

[Former Member · Accepted solution]

Thank you Thomas

[Former Member · Accepted solution]

Hi Thomas,

              I have created two stored procedures in hana. one is directly through hana modelling and other is using AMDP. Now i need to call both hana stored procedure in abap using native sql(cl_sql_statement - class).
     
             I called stored procedure using cl_sql_statement=>execute_procedure or 'execute_query', but here my problem is how to handle IN and OUT parameters of procedure.

Thanks,

Venkatesh

[Former Member · Accepted solution]

Hi Thomas,

            I followed your blog Developer's Journal: ABAP/HANA Connectivity via S... it is very helpful me to working on ADBC. I have one doubt how to handle out parameters from stored procedure. I have stored procedure with both in and out parameters. i am able to set input parameters but not able to get out parameters using execute_procedure of cl_slq

    data lr_sql type ref to cl_sql_statement.

    create object lr_sql

      exporting

        con_ref = cl_sql_connection=>get_connection( 'XSE' ).

    data lr_date type ref to data.

    get reference of lv_date into lr_date.

    lr_sql->set_param( data_ref = lr_date inout = cl_sql_statement=>c_param_in ).

    data lr_buyer type ref to data.

    get reference of lv_buyer into lr_buyer.

    lr_sql->set_param( data_ref = lr_buyer inout = cl_sql_statement=>c_param_in ).

    lr_sql->execute_procedure( proc_name = `"REALREAL"."CREATE_ORDER_ENTRY"` ).

  As reference of this example, in parameters has been set successfully but while executing procedure it is giving an error 'out parameter et_param not bound'.

   please guide me how to bound out parameter of procedure in ADBC.

Thanks,

Venkatesh