2 Replies Latest reply: May 10, 2012 11:50 PM by 801558 RSS

    java.sql.SQLException: Missing IN or OUT parameter at index:: 46

    801558
      Getting java.sql.SQLException: Missing IN or OUT parameter at index:: 46 on update statement. getting problem at BKG_OFFLOAD_STATION. I am able to get this value in java but not able to assign it to the param. please suggest. The prepared statement:
      UPDATE Booking
                SET BKG_ID = ?,
                BKG_AIRLINE_PREFIX = ?,
                BKG_STATUS = ?,
                BKG_ORIGIN = ?,
                BKG_DESTINATION = ?,
                BKG_FLEX_ROUTING_FLAG = ?,
                BKG_FUD_ORIGIN = ?,
                BKG_FUD_DEST = ?,
                BKG_DOC_ENTRY_DT = ?,
                BKG_DOC_ENTRY_FLAG = ?,
                BKG_FIRST_POS_CITY = ?,
                BKG_CREATED_DT = ?,
                BKG_LAST_UPDATED_BY =?,
                BKG_LAST_UPDATED_DT = ?,
                BKG_LAST_UPDATED_GMT_DT = ?,
                BKG_LAST_UPDATE_STATION = ?,
                BKG_VERSION_NBR = ?,
                BKG_ALLOC_FLAG = ?,
                BKG_COLOAD_FLAG = ?,
                DATED_ALLOCATION_KEY = ?,
                BKG_PSH_SUFFIX = ?,
                BKG_CHANNEL_CODE = ?,
                BKG_CREATED_CHANNEL_CODE = NVL(?,?), -- nvl(createdChannelCode,channelCode)
                BKG_CAMPAIGN_ID = ?,
                BKG_CLD_AIRLINE_PREFIX = ?,
                BKG_CLD_ID = ?,
                BKG_CLD_PSH_SUFFIX = ?,
                BKG_LAST_MESSAGE_SEQ_NO = ?,
                BKG_LAST_UPDATED_TERM_ID = ?,
                BKG_PARTSHIP_FLAG = ?,
                BKG_EVALUATION_STATUS = ?,
                BKG_RECEIVED_FROM= ?,
                BKG_STANDING_ALLOCID=?,
                BKG_STANDING_FLTDEPDT =?,
                BKG_STANDING_FLTNO=?,
                BKG_STANDING_CARRIER=?,
                BKG_GO_SHOW_FLAG=?,
                BKG_NO_SHOW_FLAG=?,
                BKG_LATE_SHOW_FLAG=?,
                BKG_BACK_LOG_FLAG=?,
                CARGO_RECEIPT_FLAG = ?,
                OPERATIONAL_HANDOVER_FLAG = ?,
                BKG_MIXED_LOAD = ?,
                SALES_OFFICE = ? ,
                BKG_OFFLOAD_STATION = ?     WHERE BKG_KEY = ?