Question Re: Stored procedure parameter definition(Table Type Definition) in Technology Q&A

Stored procedure parameter definition(Table Type Definition)

Former Member — Wed, 01 Jul 2015 14:11:25 GMT

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

Re: Stored procedure parameter definition(Table Type Definition)

thomas_jung — Wed, 01 Jul 2015 14:21:53 GMT

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

Re: Stored procedure parameter definition(Table Type Definition)

Former Member — Thu, 02 Jul 2015 06:46:02 GMT

Thank you Thomas

Re: Stored procedure parameter definition(Table Type Definition)

Former Member — Thu, 02 Jul 2015 10:39:20 GMT

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

Re: Stored procedure parameter definition(Table Type Definition)

Former Member — Tue, 14 Jul 2015 07:45:25 GMT

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