actually I just found this in the docs:

The default width of datatype columns is the width of the column in the
database. The column width of a LONG, CLOB, NCLOB or XMLType defaults to the
value of SET LONGCHUNKSIZE or SET LONG, whichever is the smaller,

so I set BOTH LONG and LONGCHUNKSIZE to 32K and it worked beautifully.

thx
bill

-----Original Message-----
Sent: Tuesday, September 24, 2002 5:29 PM
To: Multiple recipients of list ORACLE-L


If it's long then use: set long <big number>

-----Original Message-----
Sent: Tuesday, September 24, 2002 5:09 PM
To: Multiple recipients of list ORACLE-L


I've just begun playing with XML stuff in 9i (9.2.0) so please forgive what
might be an obvious question . . . 
I have a query to select data - returns two rows, in XML format (using
XMLELEMENT for each field).

The results for each row get truncated, and I can't figure out which
parameter controls this output - tried various SQL*Plus params (linesize,
pagesize, etc) but no luck.

this is the output - 

LOANAPP
---------------------------
<LoanApplication>
  <LoanRec>24977</LoanRec>
  <LoanID>L024977</LoanID>
  <Borro

<LoanApplication>
  <LoanRec>24977</LoanRec>
  <LoanID>L024977</LoanID>
  <Borro

thanks

bill
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Magaliff, Bill
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Magaliff, Bill
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Reply via email to