Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Exec procedure with variables

  1. #1
    Join Date
    Apr 2009
    Posts
    16

    Default Exec procedure with variables

    Hello everybody,

    is it possible to exec a procedure on an oracle database with variables?
    My stored procedure needs four parameters. I used the get variable step for the first parameter (named pc_wert) and the generate rows step for the other three parameters.
    When I run the job, the following error appears:
    Code:
    2009/05/08 14:50:46 - Call DB Procedure.0 - ERROR (version 3.1.3.1, build 123 from 2009/03/10 18:43:46) : Error finding field: pc_wert]
    2009/05/08 14:50:46 - Call DB Procedure.0 - ERROR (version 3.1.3.1, build 123 from 2009/03/10 18:43:46) : Because of an error, this step can't continue: 
    2009/05/08 14:50:46 - Call DB Procedure.0 - ERROR (version 3.1.3.1, build 123 from 2009/03/10 18:43:46) : Couldn't find field 'pc_wert' in row!
    In my opinion the call procedure steps only takes the fields from the generate rows step although the call procedure step lists all four field, when i click on "get fields".
    Can anyone help me with that??

    Thanks in advance, Raphael

  2. #2
    Join Date
    Dec 2008
    Posts
    11

    Default

    Check my transformation.
    I have a similar case.

    zrezur aka Daniel Polaczanski
    Attached Files Attached Files

  3. #3
    Join Date
    Apr 2009
    Posts
    16

    Default

    Thank you very much

    I just had to switch the steps generate rows and get variable T_T

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.