Re: help please

From: Mark Gumbs <mgumbs--AT--hotmail.com>
Date: Fri, 14 May 1999 16:02:36 +0100
Message-ID: <373c38f0.0@145.227.194.253>

In an insert into......select from clause, one of the select from columns cannot be a long, long raw or anything to do with long in fact. You may have to export the table in some way and sqlload it.

Mark

minalshah_at_my-dejanews.com wrote in message <7hhchb$7co$1_at_nnrp1.deja.com>...
>Hi,
> I'm trying to copy an image from one table to another and I'm
>getting error , Illegal use of long Raw
>
>My query is
>"insert into magimgtable (revid, img) select 1, img from scantable
>Where docid = 1 And batchid = 2"
>
>
>Can anyone help me on this
>How can I copy image from one table to other in oracle
>
>Thanks a lot in advance
>My eamil address is mshah_at_cgscai.com
>
>
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---
Received on Fri May 14 1999 - 10:02:36 CDT