Hello Karl,
the problem is that varchar is a character string with a fix length. Long
is a character string with a variable length. This is why you get the
message "Inconsistent datatypes".
Are you using PL/SQL? I wonder if it is possible to store a varchar column
in a long variable? I don't know, if you can really do it in one statement.
There is nothing like a "TO_LONG"-Procedure (as far as I know).
Sorry that I can't help you more with that.
Good luck.
Corinna Jaeger
Karl Kreiner <administrator_at_carinthia.com> wrote in article
<379ECDD8.B71B3091_at_carinthia.com>...
> hi everyone,
> I'm using ORACLE 8.i have following problem :
> I have a table with 3 fields (let's say a,b,c) :"a" and "b" are
> VARCHAR(2000) "c" is a LONG text.
> I want to concatenate those 3 fields and put them into a new table with
> only
> one field LONG. (let's call it D)
> Problem:
> I've tried this with
>
> insert into new_table (d) select a || b || c from old_table;
>
> result:
>
> ORA-00932: inconsistent datatypes
>
> Is there any possibility to solve this with only one sql statement ?
>
> any help is appreciated., thx charly
>
>
>
Received on Fri Jul 30 1999 - 06:54:21 CDT
