ORA-01489 Result of string concat is too large
427608Jan 19 2006 — edited Jun 28 2010On Oracle 9i R2, I have a table tblA(id varchar2(14), title varchar2(500), company varchar2(500), description varchar2(4000), dept varchar2(250), unit varchar2(250)....)
I need to create a flat [demilited] file. The script I created works for about 10-15 rows before failing with ORA-01489 error.
Please guide.