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,

      S.Q