my procedure contains

IS
v_amt number(5);
v_offset number(5);
CLOB_QUERY CLOB := EMPTY_CLOB;

v_query1 varchar2(4000):='';
v_query2 varchar2(4000):='';
v_query3 varchar2(4000):='';
v_query4 varchar2(4000):='';
v_query5 varchar2(4000):='';
query varchar2(4000):='';
BEGIN
--DBMS_LOB.WRITE(CLOB_QUERY,0,1,'');

query := ' SELECT REGION,PNL,SUBPNL,(SUM(QTDWIN) +SUM(QTDPLUGS) ) QTDWON, SUM(ROLL_UP) ROLL_UP, ';
dbms_output.put_line(length(query)||'.....'||query );
DBMS_LOB.WRITEAPPEND(CLOB_QUERY, LENGTH(query), query);

............. some code......



i m getting error is

ORA-22275: invalid LOB locator specified
ORA-06512: at "SYS.DBMS_LOB", line 722
ORA-06512: at "CMF.EBZP_OPPTY_PKG", line 33
ORA-06512: at "CMF.EBZP_OPPTY_SUMMARY", line 48
ORA-06512: at line 5


but i chked signature of method, argument types, clob locater everything seems to be ok...

Please help me out..