Skip to Content
0

Call function inside Procedure in Hana

May 04, 2017 at 11:17 AM

69

avatar image

2 Questions:

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.

Ex:

FUNCTION "VSAGARREDDY"."localqa.kranthi.Viswa::TABLE_FUNC" ( LV_BSART NVARCHAR(4) ) RETURNS TABLE ( EBELN NVARCHAR(10) , BSART NVARCHAR(4)) LANGUAGE SQLSCRIPT

SQL SECURITY INVOKER

AS BEGIN

var_out = SELECT * FROM ZTAB WHERE BSART = LV_BSART;

RETURN :VAR_OUT;

END;

============================================================

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers