Skip to Content

Table Variable as Input parameters

Hi Experts,

Can you please tell me what is the use of tables variables in procedures defined as Input parameters.

say i have created a procedure as

CREATE PROCEDURE ABC (IN ITAB TY_IN, OUT T_OUT TY_T )

LANGUAGE SQLSCRIPT READS SQL DATA WITH RESULT VIEW ABC_VIEW AS

where Itab--> is Tables Variable defined as input Parameters.

When I call this procedure, I am getting an error: Parameterizing Table Variable is not supported

Thanks and Regards,

Nag

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jun 14, 2013 at 03:27 PM

    Hi Nag,

    I am currently on rev 56 and tried to use the procedure with table input and output parameters. It works for me without any errors.

    Can you please confirm which revision you are currently working on. Also if possible, please post your code.

    Regards,

    Ravi

    Add comment
    10|10000 characters needed characters exceeded