ORACLE中分页查询时，报错：ORA-22922 :nonexistent LOB value的解决方案

原sql：

select *
  from (select tmp_result.*, rownum row_id
          from (select file_id,
                       to_char(wm_concat(distinct b.name)) name,
                       min(b.last_audit_usercode) last_audit_usercode,
                       min(b.last_audit_username) last_audit_username
                  from test b
                 group by file_id) tmp_result
         where rownum <= 10000)
 where row_id > 0

报错ORA-22922 :nonexistent LOB value

调整后的sql：

select *
  from (select tmp_result.*, rownum row_id
          from (with tmp as (select /*+ materialize */ file_id,
                                    to_char(wm_concat(distinct b.name)) name,
                                    min(b.last_audit_usercode) last_audit_usercode,
                                    min(b.last_audit_username) last_audit_username
                               from test b
                              group by file_id)
                 select * from tmp) tmp_result where rownum <= 10000
        )
 where row_id > 0

正常运行