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

From: Tom Williams <towi_at_dr.dk>
Date: 17 Dec 2002 03:41:32 -0800
Message-ID: <69f96e74.0212170341.d88491@posting.google.com>

Thanx - works now.

I actually tried that to start with (with some modification)...

strlength := length(str);

.
.
.

str := str || chr(10);
dbms_lob.writeappend(f_clob, strlength+1, str);

but that call failed (I had to take a length of str at write time) and then I saw in all the examples in the Oracle documentation they used maxsize for the binary integer, so that is why I started using that.

• Tom

"Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in message news:<at7f0b$iqs$1_at_babylon.agtel.net>...
> > 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).
Received on Tue Dec 17 2002 - 05:41:32 CST