Re: Oh, how I hate LONGs!

 Bill,

You answer is right here. Visit regularly.

http://www.cco.net/~katkins/oratip/

Cecil

Bill Meahan wrote in article <33D398A2.5A83_at_ford.com>...

>UNCLE! I give up!!
>
>How the bloody h$## do I copy a LONG field from one table to another?
>
>I'm trying to do some data archiving - moving "closed" records out of
>the "OLTP" section of my application to an "archive/reporting" area in
>another tablespace. Same database, same instance. I have some tables
>consisting of a primary key field (VARCHAR2(15)) and a LONG. All I want
>to do is copy a record from table_1 to table_1_archive.
>
>Bloody LONG's can't appear in subqueries so I can't do a
>
> INSERT INTO table_1_archive
> ( pk_field_name, long_Field_name)
> SELECT pk_field_name, long_field_name
> FROM table_1
> WHERE pk_field_name = 'pk value'
>
>So how **do** I copy the darned thing????? Do I really have to write an
>external PRO*C program to do it (gosh I hope not!)??
>
>(I also have to do updates but the same issues applu to UPDATE ...
>SELECT)
>
>--
>Bill Meahan wmeahan_at_ford.com
>Ford Motor Company -- End User Support - North America
>Not an official statement of Ford Motor Company or anyone else
>except the author.
Received on Mon Jul 21 1997 - 00:00:00 CDT