Insert using LONG data type

I am having problems inserting using a "LONG" datatype. Here is an example

INSERT INTO A(x,y,z)
select x,y,z
from B;

I get an error saying misuse of LONG data type if "x" in table A and Table B are both longs. I cannot see anything in the Oracle books that I have read that this should be a problem. There are some restrictions using a LONG data type but I don't see one using it with an INSERT except you can't use it in the "where" clause.

Thanks Received on Tue Nov 25 1997 - 00:00:00 CST