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.

2

You need to post your SQL query (your code) and your full database table schema if you wish any meaning technical support.

3

What SQL query you are using for Fetching the data?