> I don't have the access or authority to change the data type from long
> to BLOB or CLOB or something else. I tried "set long" but it doesn't
> seem to have an effect. Can I set some other values in sqlplus to make
> this work?
Unlikely. Try using SQL*Loader for this. Too bad you can't change the
column to CLOB - with DBMS_LOB chunked API you'd have a way for
doing this in SQL*Plus...
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
Received on Tue Dec 17 2002 - 04:50:59 CST
