Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Parameters were not returning values

  1. #1
    Join Date
    Apr 2007

    Default Parameters were not returning values

    The parameters which are passed as INOUT to 'Call DB procedure' are not returning with the updated values.

    The value 100 is passed to procedure 'SAMPLE(RATE IN OUT SAMPLE)' whose paramter type is 'IN OUT' with Parameter name 'RATE'.

    In the procedure the step
    RATE := RATE + 200 is added.

    The procedure is then connected to a file to see the RATE Value.

    I was expecting a value of '300' but I am getting 100.

    Please help me if someone is aware of why this is.


  2. #2
    Join Date
    Nov 1999


    Looking at the code it's highly likely that a field with the same name is being added with the new value.
    File a bug report with a simple sample.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.