Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Call DB Procedure Step

  1. #1
    Join Date
    Sep 2014
    Posts
    6

    Default Call DB Procedure Step

    I am trying to call a Oracle PL/SQL stored procedure using Call DB procedure step. All I have in my transformation is DB Procedure step and Text file. The DB Procedure returns rows of data with many columns. The DB procedure is erroring out with a Java Null Point exception.

    My transformation

    Call DB Procedure ------------> Text File Output

    Is this not valid?

    Name:  Db proc.jpg
Views: 235
Size:  23.8 KB
    Last edited by msunny; 12-01-2014 at 11:11 PM.

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

    Default

    Call DB Procedure is not an Input step, so you can't start a Transformation with it.
    Put a Generate Rows, or a Data Grid in front of the DB Procedure step, and let us know how that works for you.

  3. #3
    Join Date
    Sep 2014
    Posts
    6

    Default

    That worked. How do I capture the result set and write to a file or a DB table? The Stored Procedure returns multiple rows and multiple columns.

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

    Default

    Then perhaps you should try calling it in a Table Input step instead...

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.