"Magaliff, Bill" wrote:
>
> 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
col loanapp format A500 ?
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
INET: sfaroult_at_oriole.com
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: ListGuru_at_fatcity.com (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).
Received on Tue Sep 24 2002 - 16:33:27 CDT
