Skip to Content
avatar image
Former Member

Call function inside Procedure in Hana

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers