Skip to Content
0
Former Member
Nov 05, 2015 at 08:16 AM

Procedure call in wrapper procedure from SQL Console Error

263 Views

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!!