Skip to Content
Jul 23, 2018 at 08:33 AM

HANA Table Functions SQL script

611 Views Last edit Jul 23, 2018 at 08:34 AM 2 rev

Dear All,

HANA studio(SQL)

Table function 1.:


It_output = select * from table_function2 (:it_data);


Table_Function 2 :: (in IT_INPUT Table (xyz) );


DECLARE CURSOR c_cursor3 (cur_ident3 varchar(20)) FOR select *

from :IT_input ;

Here I want to use IT_INPUT table using For Loop cursor statement; But I am getting error as "

Cannot use local temporary table inside a procedure/function:


Please suggest? Is there any alternative.

Is it possible to call table function within same table function?