Inserting Oracle long datatype

Hi,

I am trying to add a record into a table containing a long datatype,

I concatenate a string together it is 8000 chars long in variable named b

insert statement is this,

 insert into literature_page values ('" + litId + "', '" + pgId

                                    + "', '" + b + "'"

and I get the error :
oracle.jdbc.oci7.OCIDBException: ORA-01704: string literal too long

I thought I could add up to 2 gig????

What am I doing wrong?

Thanks

Ceri

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet