2013年
-
编辑 删除
加强型WM_CONCAT2函数（不受32767限制的CLOB类型）
CREATE OR REPLACE TYPE WM_CONCAT_IMPL2 AS OBJECT-- AUTHID CURRENT_USER AS OBJECT( CURR_STR nclob, -- 原来为varchar2(32767) STATIC FUNCTION ODCIAGGREGATEINITIALIZE(SCTX IN OUT WM_CONCAT_IMPL2) RETURN NUMBER, MEMBER FUNCTION ODCIAGGREGATEITERATE(SELF IN OUT WM_CONCAT_IMPL2, P1 IN nclob) RETURN NUMBER, MEMBER FUNCTION ODCIAGGREGATETERMINATE(SELF IN WM_CONCAT_IMPL2, RETURNVALUE OUT nclob, FLAGS IN NUMBER)
