help - truncated columns

From: wpi_cs509 <wpi_cs509_at_yahoo.com>
Date: 24 Aug 2004 09:39:36 -0700
Message-ID: <58d5ee12.0408240839.7f1f7207_at_posting.google.com>

I'm using TOAD to query an Oracle 9i database. I have multiple select queries similar to this one, executing sequentially 'as a script':

select '<Country>', cntry_cd,
'</Country><Department>99999</Department><State>', st_cd, '</State><Group>999</Group><Transaction>99999</Transaction><TransactionDate>2004-08-18</TransactionDate><ID>', unique_id, '</ID><Index>2</Index>'
from tbl_lookup where cntry_cd = 'USA'

	   and rownum < 500
	   and company_nm like '%.%'

order by unique_id

I'm expecting the data to look something like this:

<Country>USA</Country><Department>99999</Department><State>MA</State><Group>999</Group><Transaction>99999</Transaction><TransactionDate>2004-08-18</TransactionDate><ID>0000067223</ID><Index>2</Index>

But, instead, I'm getting this:

<Country>USA</Country><Department>99999</Department><State>MA</State><Group>99

(truncated mid-way-ish).

Any ideas? Received on Tue Aug 24 2004 - 18:39:36 CEST