cancel
Showing results for 
Search instead for 
Did you mean: 

Procedure call in wrapper procedure from SQL Console Error

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

pfefferf
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Florian,

Thanks for your quick response.

Somehow i missed it, i know its a basic one. But anyways its working now.


Thanks!!!

Mahesh

Answers (0)