Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Parameters were not returning values

  1. #1
    Join Date
    Apr 2007
    Posts
    6

    Default Parameters were not returning values

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

    Ex:
    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.

    Thanks
    Basha

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    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.