Originally posted by tamilselvan Neither PL/SQL proc nor COPY command will work correctly when long column has more than 32K bytes data, b/c the copy command works as the same way of pl/sql.
Not true. COPY command has no limitation in data size of a long column at all and works totaly different as PL/SQL.
You can set SQL*PLus's parameter LONG to anything up to 2GB. And the setting of LONG parameter is the amount of single LONG value that COPY will deal with - the rest will be truncated. And AFAIK the maximum size of LONG can't be larger than 2GB, so tere is no actual limitation at all with COPY regarding LONGs.
Jurij Modic ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?