I am trying to call the following PLSQL and I get ORA-01008: not all variables bound
I was not able to find the missing variable as all of them are set properly
CREATE OR REPLACE PROCEDURE XXORT_INSERT_DISPOSITION
( p_orgCode INVARCHAR2
, p_orderNum IN VARCHAR2
, p_item IN VARCHAR2
, p_lot INVARCHAR2
, p_qty INNUMBER
, p_subInv INVARCHAR2
, p_status INVARCHAR2
, p_createDate IN VARCHAR2
, p_createBy INVARCHAR2
, p_updateDate IN VARCHAR2
, p_updateBy INVARCHAR2
)
IS
BEGIN
INSERT
INTO XXORT_RETURNS_DISPOSITION(ORGANIZATION_CODE,ORDER_NUMBER,ITEM_NUMBER,LOT_NUMBER,QUANTITY_SCANNED,DISPOSITION_CODE,LINE_STATUS,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY)
VALUES(p_orgCode,p_orderNum,p_item,p_lot,p_qty,p_subInv,p_status,p_createDate,p_createBy,p_updateDate,p_updateBy);
END XXORT_INSERT_DISPOSITION;
_____________________________
JAVA CODE AS FOLLOWS
------------------------------
oraclecallablestatement = (OracleCallableStatement)connection.prepareCall(sqlString);
oraclecallablestatement.clearParameters();
oraclecallablestatement.setMaxFieldSize(200);
oraclecallablestatement.setString(1, orgCode);
oraclecallablestatement.setString(2, orderNum);
oraclecallablestatement.setString(3, item);
oraclecallablestatement.setString(4, lot);
oraclecallablestatement.setDouble(5, qty);
oraclecallablestatement.setString(6, subInv);
oraclecallablestatement.setString(7, status);
oraclecallablestatement.setString(8, "SYSDATE");
oraclecallablestatement.setString(9, createBy);
oraclecallablestatement.setString(10, "SYSDATE");
oraclecallablestatement.setString(11, updateBy);
oraclecallablestatement.execute();