Re: Getting a Clob into a Long

On 10/19/2004 07:52:32 AM, Mercadante, Thomas F wrote:
> Gary,

>=20
> Just an idea - you can have multiple pl/sql long datatypes and concatenat=
e
> them together in the insert statement like this:

I believe that using the right tool for the job is OK as a general principl= e.
PL/SQL seems to be quite awkward when dealing with LONG columns, so I don't=  believe=20
that it is the right tool for the job. Other programming languages with les= s=20
constraints on the variable size and types can be more helpful. Here I am t= alking
about C/C++ as well as the interpreted scripting languages like Perl or Jav= a.
Perl has no problems with either LONG columns or BLOB columns.

--=20
Mladen Gogala
Oracle DBA

--
http://www.freelists.org/webpage/oracle-l