SELECT OID as oid,
ACCIDENT_NAME asaccidentName,
ACCIDENT_TIME as accidentTime,
ACCIDENT_TYPE as accidentType,
DEATHS as deaths,
MINOR_INJURIES as minorInjuries,
DIRCT_FINANCIAL_LOSS as dirctFinancialLoss,
PROCESSING_RESULTS as processingResults,
(select Dept_Name from SYS_ORGANIZATIONAL a
where to_char(a.OID) =UNITNAME) AS unitName,
(select Dept_Name from SYS_ORGANIZATIONAL a
where to_char(a.OID) =ACCIDENT_REPORT_UNIT) AS accidentReportUnit,
(select EMPLOYEE_NAME from SYS_EMPLOYEE a
where to_char(a.OID) =CREATETOR) AS creator
fromPMI_SAFE_ACCIDENT
一直不能运行成功,找到原因:oid设置成char类型