SQL & PL/SQL

hi all,

i'm getting an error when try to use dbms_output.put_line(myclob);

ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 116.

Where line 116 has the dbms_output.put_line statement.

I noticed that if the clob variable is not too big, it displays the values whereas my clob variable contains at least 30000 lines. i'm storing XML Spreadsheet files in it. But its not a table, just a variable.

any suggestions?

thanks
allen