Home » SQL & PL/SQL » Client Tools » Generating XML data from the daatabase... (SQL)
Generating XML data from the daatabase... [message #391733] Fri, 13 March 2009 04:19 Go to next message
Messages: 5
Registered: February 2009
Location: Bangalore
Junior Member
Hai masters,

See when i am trying to generating XML data from the database,
i am not getting output of the query entirely..
In the sense,

When i fired the following query..

select xmltype(cursor(select * from dept))
from dual;

I am getting o/p as


<?xml version="1.0"?>

But some of the result does not appear..
Is there any setup problem.

But,if execute query excluding xml function,
i am getting the entire output..
Try to give solution for this...
Re: Generating XML data from the daatabase... [message #391737 is a reply to message #391733] Fri, 13 March 2009 05:07 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
you need to change the value of the LONG environment variable in sql*Plus - this controls how much of a LONG, or LOB data type to display.

SET LONG 4000 shoulddo the trick
Previous Topic: SQL Developer
Next Topic: SQL Navigator
Goto Forum:

Current Time: Sat Aug 19 10:13:09 CDT 2017

Total time taken to generate the page: 0.04656 seconds