Re: CLOB 4000 chars

Sander wrote:

> Hello Sybrand,
>
> this cannot be the case since the error also pops up if I run a sqlplus
> query or use toad to run it. No ado involved. I only mentioned ADO to
> describe how I got to the problem description. So it is to easy to blame it
> on MS-ORA connection.
>
> If you search for "PL/SQL: numeric or value error: characterstring buffer to
> small" in combination with "CLOB" or "4000" on any oracle forums you will
> find that this particular problem is been raised several times and untill
> now I did not find one of the threads being answered.
>
> Surely there must be a way to simply store some chars in 9i (more then 4 k)
> without having to go back to longs??
>
> Regards,
>
> Sander

Can you post or send me a demo that generates the problem. I routinely work with CLOBs substantially larger than 4KB and have never had a problem.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)