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
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