Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: A Little bit of HELP with CALL DB PROC Component

  1. #1
    Join Date
    Sep 2007
    Posts
    9

    Question A Little bit of HELP with CALL DB PROC Component

    Hi ALL,

    please could you help me!

    I have created a simple function and run it on our oracle database.

    This function takes to values first one date second one varchar, output is a date with time

    the function complies with out any errors and i can call it through sqlplus and it returns the data as expected.

    The problem is in spoon i am using the Call Db Procedure component. Every time i click on find it to reference the function spoon cannot find it.

    Is kettle caching the list of procs and procedures ? I have closed spoon and started it up hoping that it would display the new function, this does not help. I have also tried to create the function with reference to the schema, even this does not help. Please could any body shed any light on what i should try next to reference the function.

    below is the function i am trying to access through the Call Db Proc component

    CREATE OR REPLACE FUNCTION GENKETTLEDATE
    (
    KETDATE DATE,
    KETTIME VARCHAR2
    ) RETURN DATE IS
    V_RTDATE DATE;
    BEGIN

    SELECT TO_DATE(TO_CHAR(TRUNC(KETDATE),'YYYY/MM/DD') || KETTIME || ':00', 'YYYY/MM/DD HH24:MI:ss') INTO V_RTDATE FROM DUAL;
    RETURN (V_RTDATE);

    EXCEPTION
    WHEN OTHERS THEN
    DBMS_OUTPUT.PUT_LINE('Excepiton.........');
    RETURN (sysdate);
    END GENKETTLEDATE;
    /

    Thank You

    Setul

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    What happens if you just enter the right function... without browsing for it.

    Regards,
    Sven

  3. #3
    Join Date
    Sep 2007
    Posts
    9

    Smile SO Sorry

    Hi So Sorry for the post.

    I used GETKETTLEDATE INSTEAD of GENKETTLEDATE

    do i changed GEN to GET

    Thanks for the reply.

    Sorry for the time wasted

    Regards

    Setul

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.