Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: call db procedure parameters

  1. #1
    Join Date
    Feb 2011
    Posts
    152

    Default call db procedure parameters

    I am successfully using the call DB procedure step to have Oracle execute procedures that we are using to load data into some tables. I can't find a way to map a field name to a particular parameter (named parameters). We have some procedures with over 30 parameters, but I only have to fill in the first 10 and the last 2. Right now, I have to fill in all parameter values with null fields so I get to the last ones. Is there a way to do a field to parameter mapping?

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Based on https://github.com/pentaho/pentaho-k...ase.java#L1037
    It looks like PDI only supports positional parameters, not named parameters.

    That seems to also be what can be found at https://github.com/pentaho/pentaho-k...ase.java#L2987
    https://github.com/pentaho/pentaho-k...ase.java#L4548

  3. #3
    Join Date
    Feb 2011
    Posts
    152

    Default

    That's what I thought by the way the step was organized. This would be a nice feature to add though.

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.