I am getting java exception error Exception(' java.sql.SQLException: Missing IN or OUT parameter at index:: 1 while trying to run below query from DB connect app v3.1.3 using rising column input.
Have Upgraded from DBX v1 to v3.1.3 and cannot get my current (DBX v1) SQL accepted.
Removing the checkpoint value line allows the GUI to run the SQL without the above error, but then it doesn't fulfill the acceptance criteria required by the GUI and i can get no further in the process.
I am no DBA and inherited the system in its current form, so without a good deal of assistance rewriting the SQL is going to be a struggle!
The reason for the DB connect upgrade is because the Database we use is moving from 11g to 12c and DBXv1 will not connect at all.
Please help!
Example SQL:
SELECT
SIT_TIMESTATUSCHANGEDDATE AS EVENT_TIME,
SERVICEITEM.SIT_ID,
SIT_AUDITREFERENCE AS SIT_REFERENCE,
SIT_TIMESTATUSCHANGEDDATE,
SIT_ENTERPRISE_ID AS ENTERPRISEID,
HM.HM_ID,
HM.PROTOCOL AS ACQ_PROTOCOL,
HM.MSG_TYPE AS ACQ_MSG_TYPE,
HM.INTERLOCUTOR AS ACQ_NAME,
HM.SENT_TIME AS ACQ_SENT_TIME,
HM.RECEIVED_TIME AS ACQ_RECEIVED_TIME,
HM.RESPONSECODE AS ACQ_RESPONSECODE,
'1.00' AS QUERY_VERSION
FROM
(SELECT UNIQUE(SIT_ID)
FROM
(SELECT *
FROM (SELECT SIT_ID,
SRQ_RECEIPTTIMEDATE
FROM DBHMRC.SERVICEREQUEST
ORDER BY SRQ_ID DESC)
WHERE ROWNUM < 20000)
WHERE SRQ_RECEIPTTIMEDATE > SYSDATE - 20/86400
AND SRQ_RECEIPTTIMEDATE < SYSDATE - 5/86400) SRQ
LEFT OUTER JOIN DBCLIENT.SERVICEITEM
ON SRQ.SIT_ID = SERVICEITEM.SIT_ID
JOIN DBCLIENT.HOSTMESSAGES HM
ON SRQ.SIT_ID = HM.SIT_ID
WHERE SIT_CURRENTSTATUS != 'STARTED'
AND SIT_TIMESTATUSCHANGEDDATE < SYSDATE-5/86400
{{ AND $rising_column$ > ? }}
