Re: trying to copy a long raw column

here's something from the Oracle manual

LONG columns cannot be used in the SELECT list of a subquery or queries combined by set operators (UNION, UNION ALL, INTERSECT, or MINUS). LONG columns cannot be referenced when creating a table with a query (CREATE TABLE . . . AS SELECT . . .) or when inserting into a table (or view) with a query (INSERT INTO . . . SELECT . . .).

I think u may have to insert the row without the LONG value and then update the row.

~hy

Jeremy Russell wrote in message <3617b23f.19501426_at_news.dircon.co.uk>...
>I have a table set up with a 'Long Raw' column, that contains picture
>information. The pictures display just fine in D/2000 - however, I
>would like to copy selected rows from the table. Using the SQL
>statement
>
>create table copy as select * from original
>
>only produces the error "ORA-00997: illegal use of LONG datatype" - if
>I create with "where 1=0" - I get the same - if I create a fresh and
>empty table and "insert into copy select * from original" - I get just
>the same again.
>
>How am I using the LONG datatype illegally?
>
Received on Mon Oct 12 1998 - 00:00:00 CDT