Re: more than 4000 chars?????

Look in the Application Developers (ver 8) guide at dbms_lob. You can insert and append to a LOB using this package using a pro* language tool or pl/sql.

JeC wrote:

> I had a LONG field in my DB, but i wasn't able to fill more than 4000 char
> in it, so i've changed into a CLOB field but it stil doesn't work.
> And i've red somewhere:
> "the Oracle SQL parser can only handle string literals up to 4000 characters
> in length. SQL*Plus is even more restricted. It can handle strings up to
> 2500 characters in length. From most Oracle clients, there will in fact be
> no way to insert data longer than 4000 characters long into a table"
>
> How can i create/manage a field where i can put more than 4000 chars?
>
> Please help me :)
>
> What do you, guys (and girls), use?
>
> JeC
> Cell Network France
Received on Thu Feb 22 2001 - 18:12:24 CST