3,495
社区成员
发帖
与我相关
我的任务
分享ORACLE 使用xmlagg获得clob输出问题
因为要输出xml字符串,用xmlagg 然后转成varchar2(4000)出现了超过4000个字符的情况,但是直接赋值给clob变量出错
求输出办法
create or replace rp_XXX
(
v_input varchar2,
v_output clob
)
as
begin
select xmlagg(
xmlelement("aa",
xmlattributes(t.a as "aa_1",t.b as "aa_2".... )
)
)
into v_output
from XXX as t
.....
end
以前是cast( as varchar(4000)) into v_output,没有问题,
求高手解答
求输出办法
create or replace rp_XXX
(
v_input varchar2,
v_output clob
)
as
begin
select xmlagg(
xmlelement("aa",
xmlattributes(t.a as "aa_1",t.b as "aa_2".... )
)
)
into v_output
from XXX as t
.....
end
以前是cast( as varchar(4000)) into v_output,没有问题,
求高手解答
...全文
请发表友善的回复…
发表回复
liuzyl 2011-08-11
- 打赏
- 举报
错误类型 :ora-00932 :数据类型不一致:应为number,但却获得-
