Re: Table Creation with a Long Variable

From: Maxim Krapivin <baltros_at_mail.wplus.net>
Date: Fri, 7 Aug 1998 19:54:40 +0400
Message-ID: <35cb243f.0@baltrosg2>

You can't copy columns of type Long this way. This is Oracle restriction. But you may write a stored procedure that will copy columns of other types first, and then copy a long column through a some program variable of type Long.

Maxim. maximka_kr_at_usa.net

mhalpeth_at_my-dejanews.com wrote:
>Hiya !
>
>Is there a way to create a table from a table which has a long variable
..as :
>
>Create table temp2
>as
>select * from temp1
>where col1 .....
>
>where the temp1 table has a long variable ... !! It displays the error
>message : ORA-00997: illegal use of LONG datatype
>
>Any ways to get around this ...!!
>
>Cheers !
>
>Mahesh
>Pls Cc : to mashy_at_null.net , TA
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Fri Aug 07 1998 - 10:54:40 CDT