OraFAQ Forum: JDeveloper, Java & XML » How to copy generated XML into CLOB from PLSQL?

Home » Developer & Programmer » JDeveloper, Java & XML » How to copy generated XML into CLOB from PLSQL?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to copy generated XML into CLOB from PLSQL? [message #92201]

Thu, 15 April 2004 19:36

Jerry
Messages: 21
Registered: December 1999

Junior Member

I have created a xmltype using XMLELEMENT.

Usually I would select XMLELEMENT(column..) into CLOB_VARIABLE.

But I just created a XMLELEMENT by union two sql statement.

--------------------
select XMLELEMENT(...) from table1

union all

select XMLELEMENT(...) from table2
--------------------

This statement have generated a xml that I want, but I can't pass results into an XML.

How do I get xml into Clob from function, so I can pass that out?

Thanks in advance.

Report message to a moderator

Previous Topic:	ORA-00904, ojdbc14.jar and server 8.1.7.3
Next Topic:	oracle.jdbc.driver.OracleDriver problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 15:34:35 CST 2024