select c.customer_guid,c.customer_id,c.customername,c.customertype_id,
c.Account_Status,c.paymoney,c.payway,c.numbertype,
s.servicename,s.memstarttime,s.memendtime,s.statusname from customer c
left join (
select parent_guid,min(memstarttime)memstarttime,max(memendtime)memendtime,
to_char(substr(wmsys.wm_concat(servicename),1,4000)) servicename,
to_char(wmsys.wm_concat(distinct(t1.servicedesc))) statusname
from bxg_service t left join
bxg_servicestatus t1 on t.status=t1.service_id
group by parent_guid) s on c.customer_guid=s.parent_guid
left join bxg_servicestatus st on st.service_id=s.servicename
where customertype_id=1 查询出来报“ora-22922 nonexistent LOB value错误如何解决?” 就算是CLOB类型转换成字符型太长了,但是我都substr了4000个字符啊,还是不行 求高手帮忙
c.Account_Status,c.paymoney,c.payway,c.numbertype,
s.servicename,s.memstarttime,s.memendtime,s.statusname from customer c
left join (
select parent_guid,min(memstarttime)memstarttime,max(memendtime)memendtime,
to_char(substr(wmsys.wm_concat(servicename),1,4000)) servicename,
to_char(wmsys.wm_concat(distinct(t1.servicedesc))) statusname
from bxg_service t left join
bxg_servicestatus t1 on t.status=t1.service_id
group by parent_guid) s on c.customer_guid=s.parent_guid
left join bxg_servicestatus st on st.service_id=s.servicename
where customertype_id=1 查询出来报“ora-22922 nonexistent LOB value错误如何解决?” 就算是CLOB类型转换成字符型太长了,但是我都substr了4000个字符啊,还是不行 求高手帮忙
解决方案 »
- ORACLE查询问题,新人求教
- 有一个现成的从oracle数据库倒出的*.dmp的数据库文件(带有log文件,都是完整的),如何在一个新的安装的Oracle 10g的数据库系统中把这个数据库文件倒入!
- 删除有外键的表的数据的问题!
- Oracle pl/sql编程时,运算表达式中有空值,则结果为空?如何让它忽略空值?
- oracle 能查sql server中的nchar类型的字段吗?ora-28500
- 请教一条关于BLOB的SQL语句!
- 问一下我用 database configuaration assistant建立数据库怎么需要1,2g的空间
- 过程中自定义的TYPE的TABLE 和RECORD类型都怎么用,怎么赋值呀?
- 困扰了我好几天的问题
- 十万火急!
- 各位 小弟迷糊了 关于oracle 建表的问题,比如 我有, 学生表 老师表 班级表
- 询问一个查询的方式
to_char(substr(wmsys.wm_concat(servicename),1,4000)) servicename,
to_char(wmsys.wm_concat(distinct(t1.servicedesc))) statusname
from bxg_service t left join
bxg_servicestatus t1 on t.status=t1.service_id
group by parent_guid 子查询 却不报错
// *Cause: The LOB value associated with the input locator does not exist.
// The information in the locator does not refer to an existing LOB.
// *Action: Repopulate the locator by issuing a select statement and retry
// the operation.
应该是数据类型问题