Don't use long use clobs. Longs are deprecated and not as flexible. You
are running into the problem that you can't do a create table as select with
a long.
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"harish" <harishksh_at_yahoo.com> wrote in message
news:ff46df6e.0302211938.13d53d21_at_posting.google.com...
> i have a table X with one attribute having a long datatype.
> i am trying to cretae another table Y by writing statement
> create table Y as select * from X;
> But it is giving "invalid use of null" error
> what is the error and give solution?
Received on Sat Feb 22 2003 - 02:27:54 CST
