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
ecearund
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
DBMS_METADATA.GET_XML('TABLE','EMP')

--------------------------------------------------------------------------------

------------------------------------------------------------------------------------------------------------------------
<?xml version="1.0"?>
<ROWSET>
<ROW>
<DEPTNO>10</DEPTNO>
<DNAME>ACCOUNTING<


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
JRowbottom
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 Navigator
Next Topic: PL/SQL Developer and OID
Goto Forum:
  


Current Time: Fri Dec 02 16:37:16 CST 2016

Total time taken to generate the page: 0.08473 seconds