Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Db Procedure Call Error

  1. #1
    Join Date
    Sep 2007
    Posts
    9

    Smile Db Procedure Call Error

    Hi I have looked up many of the forum entries about DB Procedure

    The i am getting is as follows

    2007/09/20 12:33:04 - CALLPODPROC - Step [Call DB Procedure.0] initialized flawlessly.
    2007/09/20 12:33:04 - CALLPODPROC - Transformation has allocated 3 threads and 2 rowsets.
    2007/09/20 12:33:04 - Get System Info.0 - Starting to run...
    2007/09/20 12:33:04 - Calculator.0 - Starting to run...
    2007/09/20 12:33:04 - Get System Info.0 - Signaling 'output done' to 1 output rowsets.
    2007/09/20 12:33:04 - Get System Info.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
    2007/09/20 12:33:04 - Calculator.0 - Signaling 'output done' to 1 output rowsets.
    2007/09/20 12:33:04 - Calculator.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
    2007/09/20 12:33:04 - Call DB Procedure.0 - Starting to run...
    2007/09/20 12:33:04 - TESTRACKASP - DBA setting callableStatement to [{ ? = call PROC_IMPORTPODS ( ?, ?)}]
    2007/09/20 12:33:04 - Call DB Procedure.0 - ERROR (version 2.5.1, build 1 from 2007/09/20 11:41:00) : Because of an error, this step can't continue:
    2007/09/20 12:33:04 - Call DB Procedure.0 - ERROR (version 2.5.1, build 1 from 2007/09/20 11:41:00) : Unable to call procedure
    2007/09/20 12:33:04 - Call DB Procedure.0 - ERROR (version 2.5.1, build 1 from 2007/09/20 11:41:00) : ORA-06550: line 1, column 13:
    PLS-00222: no function with name 'PROC_IMPORTPODS' exists in this scope
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored

    2007/09/20 12:33:04 - Call DB Procedure.0 - Signaling 'output done' to 0 output rowsets.
    2007/09/20 12:33:04 - TESTRACKASP - Connection to database closed!
    2007/09/20 12:33:04 - Call DB Procedure.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)
    2007/09/20 12:33:04 - Spoon - The transformation has finished!!


    The procedure takes two values and then does the processing . First value is set as in second as out for any errors.

    I am passing the arguments from the parent job to this transformation which has a getsysteminfo component. Then i am passing the values to the procedure using the DB PROCEDURE component. I am currently using kettle 2.5.1 could you help me

    Regards

    Setul

  2. #2
    Join Date
    Sep 2007
    Posts
    9

    Red face Disregard this post

    Hi sorry for the post.

    I went through the procedure call documentation and found out what is was doing wrong.

    It works fine now. Thanks for your time.

    The mistake i had done was i had left the Result name populated thus the component presumed the call was for a function.

    Once i had removed the value from this field the procedure worked.

    Hope this help others

    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.