Re: Problems writing to a temporary lob in PL/SQL

> dbms_lob.write(f_clob, b_int, 1, str);
This line should read

dbms_lob.write(f_clob, length(str), 1, str);

or

dbms_lob.writeAppend(f_clob, length(str), str);

if you want to append str to CLOB rather than overwrite portion of it starting at position 1.

Second argument says how much characters should be copied from the string. Certainly, if this value is larger than length of the string, the call fails with your error (value out of range).

-- 
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.