VARCHAR2 TO LONG or RAW or....
Posted on 2004-11-04
Hello, I'm working with Oracle 8.1.7
SELECT descripcion1||descripcion2||descripcion3 from mytable;
Error: ORA-01489: result of string concatenation is too long
Of course, the max value for a varchar2 is 4000, here i'm trying to concat 3 varchar2(2000)
I have to make a simple SELECT statement but the problem is that I have to concatenate 3 varchar2(2000) strings into one field, and I can't do that, I can't convert TO_LOB (ORA-00932: inconsistent datatypes), neither cast as RAW (ORA-00906: missing left parenthesis (that's not true))... anyway, does anyone knows how can i do this???? Please don't tell me it can't be done, that would be really sad... ;)