Query XML field in Oracle DB

[cpacan]

Hi there,

I have a BLOB field in an Oracle DB table that will contain XML.  I need to know if I can create a query that can pull both data from this field containing XML and data from the other fields (not containing XML) in the same table.  If so, how would I go about doing this?

I appreciate any help.
???
cpacan

[bdybldr]

cpa,
I don't see any reason why you can't display both.  I haven't tried it.  What kind of data is being stored in the XML field?  Why would you want to display both?  Please provide more details. 

I would suggest encapsulating the XML in quotes (" ") or something to keep it from executing.

Have you tried it yet?  Let us know what happens.

[cpacan]

The XML field containts event log data.  I need to display both because I need to get a certain type of event for my query.  The certain type is determined by the values in several other columns in the table.  The XML field contains every type of event from a mainframe system.

I haven't tried it yet because the database hasn't been created yet.  We're still in the design process and I'm tasked with stating whether Cognos ReportNet can handle this field or not.

I'm not familiar with XML and haven't used it before therefore I asked how it would be done.  I understand that both the data and the layout of the data would be stored in this XML field.  If this is correct how would I write my query to get the data from the field while referring to the layout contained in this same field?

[bdybldr]

Can you have the event field converted to a string (sans XML tags, ect)?  Will you be displaying the XML or just using it as criteria?

[cpacan]

I will ask our DBA and respond when I get an answer.

Thanks.