Home » Developer & Programmer » JDeveloper, Java & XML » How to copy generated XML into CLOB from PLSQL?
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.
Previous Topic: ORA-00904, ojdbc14.jar and server 8.1.7.3
Next Topic: oracle.jdbc.driver.OracleDriver problem
Goto Forum:
  


Current Time: Tue Jul 27 23:06:25 CDT 2021