Re: Help with Long Column Problem

I am wonderin gif you could write some PL/SQL code to move long column data piece by piece. It's something like:

for each long column value

     if   length (data) < 32760
          insert into new table
     else
         loop through each 32760 bytes, move each section into new table
     end if

HTH. Guang

"Amy" <astearns_at_datamirror.com> wrote in message news:7743d6c3.0108220521.6ff880af_at_posting.google.com...
> Hi Roger,
>
> If you are willing to examine 3rd party software, you should examine
> DataMirror's Transformation Server. DataMirror Transformation Server
> is a high-performance peer-to-peer data integration tool that enables
> you to replicate your data across multiple platforms. That said,
> Transformation Server natively supports DB2 UDB on OS/390 (among other
> databases/platforms including Oracle, SQL Server, Sybase on OS/390,
> UNIX, Linux, AS/400, NT ...). DataMirror Transformation Server
> received top-honours in a ranking by Meta Group (Spex Research) a
> while back for ETL. More product information is available on our
> web-site (http://www.datamirror.com).
>
> Hope this helps
> Amy Stearns
>
> gamebuddah_at_hotmail.com (Roger Carden) wrote in message
 news:<fbd13bc3.0108070638.2e36f0dd_at_posting.google.com>...
> > Hello Everyone,
> >
> > I'm trying to move data between two databases and one of the columns
> > that needs to be moved is a long. Currently I have a cursor which
> > selects all the values from the remote database table (including the
> > long column), runs through the lst, and inserts the data into the
> > local database. This works fine if the value of the long column is
> > under 32760 bytes.
> >
> > However, one of the rows in the remote database has a column which is
> > currently over 45000 bytes! When I include this row in my cursor, the
> > procedure bombs, however when I exclude it, the procedure moves all
> > the other data.
> >
> > First: Is there anyway to move this data from within PL/SQL? (I am
> > aware that I may be able to use the COPY command from SQL/PLUS but
> > this will not meet the requirements that I have for this job.)
> >
> > Second: If there isn't a way to move it, is there a way to check the
> > length of Long columns and exclude any over 32760 from my cursor?
> >
> > Any help would be greatly appreciated.
> >
> > Thanks,
> > Roger Carden
> > gamebuddah_at_hotmail.com
Received on Wed Aug 22 2001 - 19:14:44 CEST