Skip to Content
0
Oct 11, 2012 at 02:48 PM

call of procedures in Hana

1221 Views

Hi experts,

I have some trouble with HANA/SQLScript.

I created a procedure like that one:

After creation I've tryed to call the procedure with something like

call "_SYS_BIC"."d052319/GET_RELEVANT_ENTITIES"( "IA_PARENT_OF_BC", out_table ); or

call "_SYS_BIC"."d052319/GET_RELEVANT_ENTITIES"( "IA_PARENT_OF_BC", :out_table );. or

call "_SYS_BIC"."d052319/GET_RELEVANT_ENTITIES"( iv_linke_type_id="IA_PARENT_OF_BC", out_table );



But all the time I've got only error messages.

You find an example here.

Does anybody know why tha call statement in the embeded SQL editor doesn't work or what I've done wrong?



Thanks to your for helpfull every feedback,

Martin

Attachments

hana_procedure.jpg (101.6 kB)