Skip to Content
-2

HANA Table Functions SQL script

Dear All,

HANA studio(SQL)

Table function 1.:

Begin

It_output = select * from table_function2 (:it_data);

End.

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

declarecur_ident3varchar(20);

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?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

0 Answers