Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Call DB Procedure with Date

  1. #1
    Join Date
    Mar 2016
    Posts
    3

    Default Call DB Procedure with Date

    Hello,

    I have some difficulties calling a stored DB procedure (Oracle Server) with PDI.

    The procedure looks like this:

    er_utils.start_testing(to_date(20160323,'YYYYMMDD'),'RUNONE');

    So the first parameters type is Date and the other String.

    Handing over the String 'RUNONE' through parameters is no problem, but I don't know how to hand over the date. I tried to convert the parameter K_DATE I defined in the transformation with Get Variables but that didn't work so far.

    KEY_DATE would have the value '20160323' in the given example of the procedure.

    How can I convert my parameter so it works with the DB procedure?


    Best regards.

  2. #2
    Join Date
    Mar 2016
    Posts
    3

    Default

    Solved the problem with the Select Values step.
    Can I delete this thread somehow?

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

    Default

    Just for interest sake, can you try running the Proc as:

    er_utils.start_testing(param1,param2);

    Where param1 is the date (as a date) in your stream, and param2 is the string 'RUNONE' (without the quotes)

    Oracle makes you explicitly switch between strings and dates, but if you have a date, you shouldn't need to convert it to be a string, just to convert it back to a date.

Tags for this Thread

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.