Bonjour,

j'utilise ibatis pour exécuter mes requêtes .Quand je lance ma requête, j'ai cette erreur :

--- The error occurred while applying a parameter map.
--- Check the AnsweredEmail.EmailsRepondusCount-InlineParameterMap.
--- Check the parameter mapping for the 'startDate' property.
--- Cause: java.sql.SQLException: Index de colonne non valide
Caused by: java.sql.SQLException: Index de colonne non valide


Voici ma requête :

SELECT DISTINCT REQ.REQUESTEMAILBOX, Count(*) AS NBREQUETES, REGEXP_SUBSTR(ACCOUNTGROUPLABELS.LABEL,'([^[:blank:]]+)') AS CRCM
FROM TMI.REQUEST REQ, TMI.REQUESTSTATEVENT RSE, TMI.STATEVENT SE, TMI.REQUESTSTATEVENTEX RSEX, TMI.ACCOUNTGROUPLABELS AGL
where
SE.EVENTDATE BETWEEN #startDate# and #endDate# AND
REQ.REQUESTID = RSE.REQUESTID AND
RSE.REQUESTEVENTKIND = 17 AND
RSE.STATEVENTID = SE.STATEVENTID AND
RSE.STATEVENTID = RSEX.STATEVENTEX1 AND
RSE.ACCGROUPID = AGL.ACCOUNTGROUPID AND
AGL.LOCALE like '%fr%' AND
RSEX.EXTYPE = 2
GROUP BY REQ.REQUESTEMAILBOX, REGEXP_SUBSTR(AGL.LABEL,'([^[:blank:]]+)')
Order by REGEXP_SUBSTR(AGL.LABEL,'([^[:blank:]]+)'),REQ.REQUESTEMAILBOX



D'où vient l'erreur ?