Re: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?

From: Steve Baldwin <stbaldwin_at_multiservice.com>
Date: Thu, 2 Sep 2010 10:17:38 +1000
Message-ID: <AANLkTimY3ECjaA_ZR3KDeNAsH43xQzXsO3x+fK-wH2yG_at_mail.gmail.com>

The problem in this case is that the data type of 'id || id' is VARCHAR2 and with Oracle, the maximum size of a VARCHAR2 column is 4000 chars.

Steve

On Thu, Sep 2, 2010 at 10:06 AM, Bill Myers <bwmyers_at_gmail.com> wrote:

> "id||id" is 4000 chars concatenated with another 4000 chars, so shouldn't
> linesize=8000 in that case?
>
>
> On Wed, Sep 1, 2010 at 4:40 PM, Michael Dinh <mdinh_at_xifin.com> wrote:
>
>> Here is a simple test case. May be I am doing something wrong, but was
>> not able to figure it out.
>>
>>
>>
>> create table t1(id varchar2(4000));
>>
>> insert into t1 values (lpad('a', 4000, 'b' ));
>>
>>
>>
>> set linesize 4000
>>
>>
>>
>> select id||id from t1;
>>
>> ERROR at line 1:
>>
>> ORA-01489: result of string concatenation is too long
>>
>>

---

This email is intended solely for the use of the addressee and may contain information that is confidential, proprietary, or both. If you receive this email in error please immediately notify the sender and delete the email.

---

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 01 2010 - 19:17:38 CDT