SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

result string concatenation too long ora 01489

948845Jul 11 2012 — edited Jul 12 2012

Hi,

I am trying to spool the data to a file , and my query has 115 columns and out of which 20 columns have varchar2(2000). And its throwing result string concatenation too long.

I tried using to_clob function , but spool file does not show the complete result set.

Can somebody please suggest a solution.

Thanks in Advance
Rashmi

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 9 2012

Added on Jul 11 2012

4 comments

827 views