on 11-05-2015 8:16 AM
Hi All,
I am trying to call a procedure which accepts a table type. I am trying to call this in a wrapper procedure in SQL Console.
create procedure test_v5 ( outtab "_SYS_BIC"."XXXtrial.hanainstance.XXX::data.procedures.errors" )
language sqlscript
as
begin
temp1 = select * from "_SYS_BIC"."XXXtrial.hanainstance.XXX.models::dataETA.ETAHISTORY"; ** this gives a table with 2 rows as a result
call "NEO_XXXX"."c5208507trial.hanainstance.XXX.procedures::ETADataCreate"(temp1,:outtab);
end;
call test_v5 () ;
drop procedure test_v5
Error i am getting:
Could not execute 'create procedure test_v5 ( outtab ...'
SAP DBTech JDBC: [7]: feature not supported: Only table variable is allowed in input parameter in a nested call: line 6 col 120 (at pos 408)
Could not execute 'call test_v5 ()'
SAP DBTech JDBC: [328]: invalid name of function or procedure: TEST_V5: line 1 col 6 (at pos 5)
Could not execute 'drop procedure test_v5'
SAP DBTech JDBC: [328]: invalid name of function or procedure: TEST_V5: line 1 col 16 (at pos 15)
Can some one please help me out?/
Thanks in advance!!
Hello Makesh,
you have to address your table "temp1" also with ":temp1" in the procedure call.
call "NEO_XXXX"."c5208507trial.hanainstance.XXX.procedures::ETADataCreate"(:temp1,:outtab);
Best Regards,
Florian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.