Passing a Non Scalar parameter to a procedure

[former_member184867]

Hello Experts,

I am using the following code to call procedure calculateInc and I am passing variable lt_l0_tmp.

    lt_l0_tmp =  select * from :lt_l0 
                 where SCOPE_OBJECT_USER_ID = wa_l0.SCOPE_OBJECT_USER_ID and TIMESTAMP < wa_l0.TIMESTAMP 
                 and   SCOPE_OBJECT_STATUS = 'READY' ;
   call calculateInc(lt_l0_tmp, :no_of_inc);

I am getting following compilation error.

SAP DBTech JDBC: [7] (at 1034): feature not supported: Only table variable is allowed in input parameter in a nested call: line 18 col 22 (at pos 1034)

How can I pass the result of select (at line no 01) to the procedure called at line 05?

Regards,

Atanu

[rindia]

Hi Atanu,

As the script you pasted here is incomplete, I hope lt_l0_tmp is defined as table type.

As lt_l0_tmp it contains more than 1 record, you cannot directly use a procedure with such a parameter.

You need to loop the table result set, pass the parameter and then call the procedure till the end of the record.

Regards

Raj