ORA-00936

[jayouzts]

I have a TOracleDataSet component with the following SQL statement:

SELECT DT.DRY_TRCKG_ID, DT.USER_ID,
DT.CRT_ID, DT.DIVISION_ID,
DT.MAST_CASE_ID, DT.DATE_DIARY,
DT.DIARY_LONG_TEXT, DT.DIARY_MESSAGE,
DT.DOCUMENT_ID, DT.DOCUMENT_TYPE,
DT.PRIORITY_FLG, DT.DATE_COMPLETED,
DT.EVENT_TRACKING_ID,
DT.EVENT_TRACKING_ID AS EVENT_CODE
JITS.F_CAT_DESCR(ET.EVENT_CODE) AS EVENT_CODE,
ET.DATE_DUE,
MCR.APP_CASE_NUM,
MCR.STYLE, ROWID
FROM JITS.DIARY_TRACKING DT,
JITS.DIARY_GROUP_USERS DGU,
JITS.EVENT_TRACKING ET,
JITS.MASTER_CASE_RECORD MCR
WHERE DT.DIARY_GROUP_ID = DGU.DRY_GRP_ID
AND DT.EVENT_TRACKING_ID = ET.EVENT_TRACKING_ID
AND DGU.USER_ID =

arm_nUserID
AND DT.MAST_CASE_ID = MCR.MAST_CASE_ID(+)
ORDER BY DT.DATE_DIARY DESC, DT.PRIORITY_FLG DESC,
DT.DRY_TRCKG_ID

Elsewhere in the code I have

theDataSet.SetVariable('parm_nUserID', 323);
theDataSet.Open;

This trips an ORA-00936 Missing Expression exception.

The Query works when I run it in SQL. It also works when I use a BDE TQuery Component.

Any ideas what I should look for?

 

[jayouzts]

BTW There was a typo in my previous post. Originally I had

DT.EVENT_TRACKING_ID AS EVENT_CODE JITS.F_CAT_DESCR(ET.EVENT_CODE) AS EVENT_CODE

The line DT.EVENT_TRACKING_ID AS EVENT_CODE is NOT in the query. Thanks.

 

[jayouzts]

disregard this inquiry. Further investigation revealed that the SQL Statement was cleared and re-defined at runtime. It was in this process that the error was introduced. Thanks