查询的问题

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类型