Re: Antw: Re: Insert 8000 Byte into LONG column

2003-07-16 Thread Jose Luis Delgado
Guido... change the datatype! :-) Of course, you can't. Well, have you tried with a Pl-Sql anonymous block? or... Oracle says that using BIND variables you can get more than 4000 chars... have you tried with bind vars? HTH JL --- Guido Konsolke Hi dear list members, we run a

RE: Antw: RE: Insert 8000 Byte into LONG column

2003-07-16 Thread Mercadante, Thomas F
Guido, Where are getting the data from - other database tables? Because, you could build a PL/SQL block that contains PL/SQL variables that can hold up to 32k of data. You could build the string in the variable and insert it into the LONG column. Something like: declare str_var