Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Help on Java Script& Stored Procedure

  1. #1
    Join Date
    Sep 2005
    Posts
    1,403

    Default Help on Java Script& Stored Procedure

    Hi,
    First thanks for replies. Comming to point we are facing some problems with Java Script and Stored Procedures, I will explain in detail:

    STORED PROCEDURE:
    1. While using Stored Procedure we are taking one source and stored procedure and target it is like
    o SOURCE ->STORED PROCEDURE->TARGET

    2. We created one stored procedure in oracle and we are calling that procedure in to kettle. The job is compiling successfully but its throwing error while we are running that job. The error message is

    o 2006/05/08 14:40:46 - Call DB Procedure.0 - ERROR: Because of an error, this step can't continue:
    o 2006/05/08 14:40:46 - Call DB Procedure.0 - ERROR: Unable to prepare database procedure call
    o 2006/05/08 14:40:46 - Call DB Procedure.0 - ERROR: Invalid column index

    JAVA SCRIPT:

    1. Comming to Java script we need help on how to write java script module in kettle.
    2. We created one job and defined java script module in script area and executed it. the job is running with out errors but the out put is not coming as per requirements.


    * Please suggest us the solutions and also suggest us where we can get material on this issues.

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default RE: Help on Java Script& Stored Procedure

    Hi AC,

    The stored producedure error can be just about anything. Since you provide no input for us to work with, I can't really say anything about it. Why not tell us at least on what database you're working and the declaration of the Stored Procedure? Then at least we can make some kind of suggestion.

    As for javascript: there's plenty of stuff in the forum, for example the first Weekly Kettle Tip was about Javascript.

    Matt

  3. #3
    Join Date
    Sep 2005
    Posts
    1,403

    Default RE: Help on Java Script& Stored Procedure

    Hi,

    We created a stored procedure which will take "arg1","arg"2 as input and gives output as "outarg", the condition we are trying is: OUTARG = ARG1 +ARG2.

    This arg1 and arg2 are the columns of the table, which is there in oracle database, and the output we are storing in text file
    Thanks & Regards
    Sasikiran.V

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.