mysql wm concat_解决 wm_concat函数 长度不够问题

自定义函数如下：

CREATE OR REPLACE TYPE "T_LINK_LOB"

AS

OBJECT

(

V_LOB CLOB,

STATIC FUNCTION ODCIAGGREGATEINITIALIZE (SCTX IN OUT NOCOPY T_LINK_LOB)

RETURN NUMBER,

MEMBER FUNCTION ODCIAGGREGATEITERATE (SELF IN OUT NOCOPY T_LINK_LOB, VALUE IN VARCHAR2)

RETURN NUMBER,

MEMBER FUNCTION ODCIAGGREGATETERMINATE

(

SELF IN T_LINK_LOB,

RETURNVALUE OUT NOCOPY CLOB,

FLAGS IN

NUMBER

)

RETURN NUMBER,

MEMBER FUNCTION ODCIAGGREGATEMERGE (SELF IN OUT NOCOPY T_LINK_LOB, CTX2 IN T_LINK_LOB)

RETURN NUMBER

)

CREATE OR REPLACE TYPE BODY T_LINK_LOB

IS

STATIC FUNCTION ODCIAGGREGATEINITIALIZE (SCTX IN OUT NOCOPY T_LINK_LOB)

RETURN NUMBER

IS

BEGIN

SCTX := T_LINK_LOB (NULL);

DBMS_LOB.CREATETEMPORARY (SCTX.V_LOB, TRUE, D