Re: XMLType in Oracle9.2i

[Marcelo F. Ochoa]

Majcen, Kurt wrote:

Hi,

has anyone already used the 'get-xml' from esql taglib with the ORACLE9.2i datatype XMLType?

We are working with Cocoon 2.0.3. We have already used the CLOB datatype and their everything works fine with get-xml (i.e. we receive the content and can display it after a transformation). After changing to XMLType which better fits our needs we no longer get results for the XML but as we select more columns we see that results are returned (i.e. the non XML containing columns can be visualised).

You can use either  CLOB storage or DOM fidelity storage of 9i XMLType, 
then if you create an XMLType table like this:
  

CREATE TABLE po_tab OF XMLTYPE 
     XMLSCHEMA "http://www.oracle.com/PO.xsd"; ELEMENT "PurchaseOrder";

 you can get the row values using an SQL like this:
   select value(p).getClobVal() as col_alias from po_tab p;
 If you have a column of type XMLType the rule are the same:
  select p.my_col.getClobVal as col_alias from my_tab p;
tia, Kurt

 

 Best regards, Marcelo.

--
Marcelo F. Ochoa - [EMAIL PROTECTED]
Do you Know DB Prism? Look @ http://www.dbprism.com.ar/dbprism/doc/Home.html
More info?
Chapter 21 of the book "Professional XML Databases" (Wrox Press 
http://www.wrox.com/)
Chapter 8 of the book "Oracle & Open Source" (O'Reilly 
http://www.oreilly.com/catalog/oracleopen/)
-----------------------------------------------
Lab. de Sistemas - Fac. de Cs. Exactas - UNICEN
Paraje Arroyo Seco - Campus Universitario
(7000) Tandil - Bs. AS. - Argentina
Te: +54-2293-444430 Fax: +54-2293-444431



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]