Re: Insert Into-why doesn't it work?

"Monica Roman" <monicaroman_at_yahoo.com> schrieb im Newsbeitrag news:9eb77af5.0304290812.49235b7f_at_posting.google.com... (snip)
> I have 2 tables that have the exact same structure:
>
> Name Type
> ------------------------------- ------------
> FIELD1 DATE
> FIELD2 VARCHAR2(30)
> FIELD3 VARCHAR2(25)
> FIELD4 CLOB
>
> I need to:
>
> INSERT INTO Table1
> SELECT * FROM Table2
> WHERE Field1 like '28-APR-03%';
>
> But it doesn't work! why? It should be so simple!!
> I read a lot of the archived messages on the subject but couldn't find
> my answer. Apparently it has to do with the LOB field, does it? Please
> help?
>
> Thank you so much!
>
> Monica

Hi Monica,

what is the error number of 'doesn't work'? Can't find it in my documentation set ;-)

And as TC and Ethel have mentioned: get rid of the implicit conversion.

My guess (sorry, can't test it right now) is, that you can't use 'INSERT INTO ... SELECT .. FROM..' when the table contains a CLOB column. I saw this behaviour with a LONG column.

hth,
Guido Received on Wed Apr 30 2003 - 15:10:57 CEST