Extracting LONG Data Type from DB via UNIX Script

Shell Programming and Scripting
1

Hi,
I want to extract a XML file which is stored in the database having a data Type as "LONG" via UNIX Scripting.

But when i am triggering the SQL via UNIX it is fetching only the first Line and not the complete XML.

Can you please suggest if the parameters that i have used needs any addition or i need to include any thing else.

The Data Type in the DB is as below.-

SQL> desc siebel.cx_prov_msg_bt
 Name                                      Null?    Type
 ----------------------------------------- --------  ----------------------------
 X_APPLN_ROW_ID                                     VARCHAR2(15 CHAR)
 X_MSG_1                                                        LONG

The SQL I am firing on the DB via UNIX. :-
-----------------------------------------------------

SET TRIMSPOOL ON;
SET NEWPAGE NONE;
SET FEEDBACK OFF;
SET ECHO OFF;
SET LINESIZE 1000;
SET WRAP OFF;
SET PAGESIZE 2000;
SET HEADING OFF;
SET TAB OFF;
SET SERVEROUTPUT OFF;
WHENEVER SQLERROR exit;

select x_msg_1 from siebel.cx_prov_msg_bt where x_appln_row_id in (
 '1-2FNEE1P',
 '1-2F7ND69');

O/P i am getting is just the 1st line of the XML :-

<?xml version="1.0" encoding="UTF-8"?><?Siebel-Property-Set EscapeNames="true"?>

:confused: