2 Replies Latest reply on Dec 16, 2010 9:39 PM by S.Q. R

    How implement in_out parameter in virtual procedure?

    S.Q. R Newbie

      Hi, All


      I have read some document and discusses. It seem that in_out parameter is not supported in virtual procedure.

      For the source stored procedure, there are some description in Teiid reference document:


      1.4.6. Procedural Relational Command
      Syntax Rules:
      The procedure as a table projects the same columns as an exec with the addition of the input parameters.For procedures that do not return a result set, IN_OUT columns will be projected as two columns, one that represents the output value and one named {column name}_IN that represents the input of the parameter.



      How can I get similar result against virtual procedure?


      Thank your very much!


      Best Regards,