Oracle中报无效数字

如下语句：

select *
  from (select rownum r, t.*
          from (select s.c_id,
                       f.c_id fileid,
                       f.c_title title,
                       l.c_id lid,
                       l.c_strshortname,
                       l.C_STRCORPNAME,
                       l.c_strshortname || p.c_packname corppack,
                       p.c_id pid,
                       p.c_packname,
                       p.c_packcode,
                       nvl(a.c_qty, 0) c_qty,
                       o.c_stockorder,
                       c.c_bzname,
                       c.c_strprodname,
                       c.c_nocodeid,
                       c.C_MEASUNIT,
                       c.C_PRICEDW,
                       a.c_iftax,
                       a.c_price,
                       (select c_explain
                          from t_supplierenter
                         where c_project = p.c_project
                           and c_supplierid = s.c_supplier) explain,
                       decode(s.c_resultstatus, '1', '已签收', '未签收') c_rs
                  from t_bidpacksupp s
                  left join t_bidpackorder o
                    on o.c_bidpack = s.c_bidpack
                  left join t_stockaffirmpart a
                    on s.c_supplier = a.c_supplier
                   and a.c_bidpack = s.c_bidpack
                   and a.c_stockorder = o.c_stockorder
                  left join t_bidpack p
                    on s.c_bidpack = p.c_id
                  left join t_stockorder c
                    on c.c_id = o.c_stockorder
                  left join t_supplier l
                    on l.c_id = s.c_supplier
                  left join t_bidattachment f
                    on f.c_project = p.c_project
                   and f.c_supplier = s.c_supplier
                   and f.c_type = 14
                 where p.c_project = 7741848774
                   and p.c_process <> 7741075449
                 order by l.c_id, p.c_id, o.c_stockorder) t
         where rownum <= 50)
 where r > 0

报无效数字，可能是字段匹配时类型不一样，修改如下即可：

select *
  from (select rownum r, t.*
          from (select s.c_id,
                       f.c_id fileid,
                       f.c_title title,
                       l.c_id lid,
                       l.c_strshortname,
                       l.C_STRCORPNAME,
                       l.c_strshortname || p.c_packname corppack,
                       p.c_id pid,
                       p.c_packname,
                       p.c_packcode,
                       nvl(a.c_qty, 0) c_qty,
                       o.c_stockorder,
                       c.c_bzname,
                       c.c_strprodname,
                       c.c_nocodeid,
                       c.C_MEASUNIT,
                       c.C_PRICEDW,
                       a.c_iftax,
                       a.c_price,
                       (select c_explain
                          from t_supplierenter
                         where c_project = p.c_project
                           and c_supplierid = s.c_supplier) explain,
                       decode(s.c_resultstatus, '1', '已签收', '未签收') c_rs
                  from t_bidpacksupp s
                  left join t_bidpackorder o
                    on o.c_bidpack = s.c_bidpack
                  left join t_stockaffirmpart a
                    on s.c_supplier = a.c_supplier
                   and a.c_bidpack = s.c_bidpack
                   and a.c_stockorder = o.c_stockorder
                  left join t_bidpack p
                    on s.c_bidpack = p.c_id
                  left join t_stockorder c
                    on c.c_id = o.c_stockorder
                  left join t_supplier l
                    on l.c_id = s.c_supplier
                  left join t_bidattachment f
                    on f.c_project = to_char(p.c_project)  --修改此处
                   and f.c_supplier = to_char(s.c_supplier)  --修改此处
                   and f.c_type = 14
                 where p.c_project = 7741848774
                   and p.c_process <> 7741075449
                 order by l.c_id, p.c_id, o.c_stockorder) t
         where rownum <= 50)
 where r > 0