Re: copy long raw

Hui, Kwok Miu wrote:
>
> Herald ten Dam wrote:
>
> > I'm trying to copy a long raw (OLE-object) from one table to another
> > table. I programmed this with PRO*C with dynamic method 4. This works
> > for some small objects (long raws). I put the size for such object to
> > 3MB. The object who didn't succeed was probalbly 60K. Does someone know
> > what went wrong? Is there a limit with OLE-objects? Does someone know a
> > solution? Can it be done with OLE, or has somebody also a PRO*C copy
> > routine?
>

Use the copy command in sqlplus. Do a "set long 64K" before doing a copy. Copy will work between difference instances on the same machine, between different servers across the network, or simply within the same instance on the same machine. I use it for all my table copies that involve long fields.. Received on Tue Nov 26 1996 - 00:00:00 CET