SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CLOB : ORA-06502: PL/SQL: numeric or value error

Pradhyumn (PS)Apr 8 2012 — edited Apr 9 2012

Hi,
Database : 10g
I have searched on net/ threads for solution of this error, but i didn't find the solution. help to resolve error

CREATE OR REPLACE function fn_clob return clob
is
v_clob clob;
c_clob clob:='';
begin
  dbms_output.ENABLE;
  DBMS_LOB.createtemporary (c_clob, TRUE);
  DBMS_LOB.createtemporary (v_clob, TRUE);
for i in 1..10000 
loop
v_clob := v_clob||'<tr><td> '||i||'</td></tr>';
dbms_lob.writeappend(c_clob, length(v_clob), v_clob);
end loop;
return v_clob;
dbms_output.put_line('Out: '||v_clob);
end;

Locked Post

New comments cannot be posted to this locked post.

Locked on May 7 2012

Added on Apr 8 2012

6 comments

13,855 views