1)I Have created Table Function in Hana and same function i want to call inside the Procedure.
In Function we have Return table (Return :Var_out), So i want to use this Var_out data in procedure and do further manipulations in the procedure.
So how to get the Var_out table in the Procedure.
FUNCTION "VSAGARREDDY"."localqa.kranthi.Viswa::TABLE_FUNC" ( LV_BSART NVARCHAR(4) ) RETURNS TABLE ( EBELN NVARCHAR(10) , BSART NVARCHAR(4)) LANGUAGE SQLSCRIPT
SQL SECURITY INVOKER
var_out = SELECT * FROM ZTAB WHERE BSART = LV_BSART;
Now i have created procedure and inside procedure i want to use the function and get the function var_out table data in the procedure for further validations.
Inside procedure i have called function :
SELECT * FROM "VSAGARREDDY"."localqa.kranthi.Viswa::TABLE_FUNC"( 'ZNB1' )
but here i am not getting idea how to get function var_out table data in the procedure.
Kindly help me and send me step by steps.
2) i have created table type with 2 fields by using SQL script.
Now i want to add one more field in the table type or change existing filed in the table type.
i tried with graphical by right click , but it is not edit option and also tried with SQL alter table type. finally nothing worked and unable make change.
Kindly help me how to do it.