现在是server2008 R2的操作系统，oracle 11，现在打开日程中的工作计划就报错，不分用户，如下。
ORA-01790: expression must have same datatype as corresponding expression
{"operation":"CRM_ACTIVITY_List.GetEntryData"}]
发生时间： 2015-07-23 03:21:13
错误编号： BOS_ExecuteReader
错误信息： ORA-01790: expression must have same datatype as corresponding expression
Sql语句： SELECT * FROM (SELECT t0.FBILLNO FBILLNO, t0.FNAME FNAME, t0.FASSIGNERID FASSIGNERID_ID, t0.FPLANSTARTTIME FPLANSTARTTIME, t0.FPLANENDTIME FPLANENDTIME, t0.FDURATION FDURATION, t0.FALERTFLAT FALERTFLAT, t0.FACTSTARTTIME FACTSTARTTIME, t0.FACTENDTIME FACTENDTIME, t0.FRESULT FRESULT, t0.FDESCRIPTION FDESCRIPTION, t0.FREMARKS FREMARKS, t0.FCREATORID FCREATORID_ID, t0.FCREATEDATE FCREATEDATE, t0.FSTATUS FSTATUS, t0.FCUSTOMERID FCUSTOMERID_ID, t0.FESSENTIALITY FESSENTIALITY_ID, t0.FACTIVITYTYPE FACTIVITYTYPE_ID, t0.FPREDAYS FPREDAYS, t0.FPREACTIVITYID FPREACTIVITYID_ID, t0.FPRETYPE FPRETYPE, t0.FSOURCEBILLTYPE FSOURCEBILLTYPE, t0.FSOURCEBILLNO FSOURCEBILLNO, t0.FORGID FORGID, t0.FORGID FORGID_ID, t0.FID FID, ROW_NUMBER() OVER( ORDER BY t0.FID ASC) FIDENTITYID FROM T_CRM_Activity T0
推荐阅读