Java Development Tools

Hi Guys,

Can anyone help on this issue.

I have a stored procedure as follow:

create or replace PACKAGE BODY X_LOAD_THERMAL_RATINGS_PKG

AS

  PROCEDURE X_THERMAL_RATINGS_LOAD(

      V_TRANSACTION_ID           IN OUT VARCHAR2,

      V_TRANSACTION_TIMESTAMP    IN TIMESTAMP,

      V_TRANSACTION_DATAPROVIDER IN VARCHAR2,

      V_NASAP_CODE               IN VARCHAR2,

      V_CHANNEL_SCHEDULE_ID      IN VARCHAR2,

      COMMISSIONG_STATUS         IN VARCHAR2,

      V_PUBLISHED_TIMESTAMP      IN TIMESTAMP,

      V_VALID_FROM               IN TIMESTAMP,

      V_VALID_TO                 IN TIMESTAMP,

      V_IS_DOWNRATED             IN CHAR,

      V_RATING_SCENARIO          IN VARCHAR2,

      V_DATAPROVIDER_CODE        IN VARCHAR2,

      V_RATING_SCHEDULE_DESC     IN VARCHAR2,

      V_RATING_SCHEDULE_COMMENT  IN VARCHAR2,

      V_SCHEDULE_TYPE            IN VARCHAR,

      V_SCHEDULE                 IN X_SCHEDULE_TBL,

      V_ASSET                    IN X_ASSET_TBL,

      V_STATUS OUT VARCHAR2 ,

      V_ERROR_MSG OUT VARCHAR2)

My java code as follows:

            DBTransactionImpl oadbtransactionimpl = (DBTransactionImpl) this.getTransaction();

            OracleConnection conn = this.getJDBCConnection(oadbtransactionimpl, resultMap);

            ArrayDescriptor arrydesc = ArrayDescriptor.createDescriptor("X_SCHEDULE_TBL", conn);

            ArrayDescriptor arrydesc1 = ArrayDescriptor.createDescriptor("X_ASSET_TBL", conn);

            Array orderDetailArray = new ARRAY(arrydesc, conn, recList.toArray());

            Array orderDetailArray1 = new ARRAY(arrydesc1, conn, recList1.toArray());

                        java.sql.Date sqlendDate = new java.sql.Date(new Date().getTime());

            Timestamp startDateTime = new java.sql.Timestamp(new Date().getTime());

            CallableStatement cs =

                         getDBTransaction().createCallableStatement("begin X_LOAD_THERMAL_RATINGS_PKG.X_THERMAL_RATINGS_LOAD(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19); end;",0);

            cs.registerOutParameter(1, Types.VARCHAR);

            cs.setTimestamp(2,startDateTime);

            cs.setString(3, "A14B");

            cs.setString(4, "A14B");

            cs.setString(5, "1254");

            cs.setString(6, "Pre-commissioned");

            cs.setTimestamp(7, startDateTime);

            cs.setTimestamp(8, startDateTime);

            cs.setTimestamp(9, startDateTime);

            cs.setString(10, "N");

            cs.setString(11, "Standard");

            cs.setString(12, "A14B");

            cs.setString(13, "Testing vinod");

            cs.setString(14, "Vinod Gummadi testing");

            cs.setString(15, "Default");

            cs.setArray(16,orderDetailArray);

            cs.setNull(17,java.sql.Types.STRUCT, "X_ASSET_OBJ");

            cs.registerOutParameter(18, Types.VARCHAR);

            cs.registerOutParameter(19, Types.VARCHAR);

         cs.execute();

when executing getting error . can anyone help me on this