Home » Other » 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...

Report message to a moderator

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

Report message to a moderator

Previous Topic: SQL Navigator
Next Topic: PL/SQL Developer and OID
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 06:49:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.