I am extracting data from an Oracle data to XML. I have the query working
perfectly and the XML
file gets created no problem. However, I am getting an extra level when I use
a CURSOR in my
query.
I have an Oracle query like this:
SELECT protocol, study_title, (CURSOR select indication from tab2 where
tab2.col1 = tab1.col1)
as indications, sched_end_date
FROM tab1
using no stylesheet at all my XML looks like this:
<example>
<Study>
<protocol>Protocol 1</protocol>
<study_title>Study to test herpes in chickens</study_title>
<colloquial_name>ABC1234</colloquial_name>
<indications>
<indications_row num="1">
<indication>Breast Cancer</indication>
</indications_row>
<indications_row num="2">
<indication>Cervical Cancer</indication>
</indications_row>
<indications_row num="3">
<indication>Colorectal Cancer</indication>
</indications_row>
<sched_end_date>20-APR-2006</sched_end_date>
</Study>
</example>
I would like to eliminate the layer with the <indications_row num="1">.... so
that it looks like
this:
<example>
<Study>
<protocol>Protocol 1</protocol>
<study_title>Study to test herpes in chickens</study_title>
<indications>
<indication>Breast Cancer</indication>
<indication>Cervical Cancer</indication>
<indication>Colorectal Cancer</indication>
<sched_end_date>20-APR-2006</sched_end_date>
</Study>
</example>
I've tried using xsl to eliminate it but haven't had any luck. I'm new to xsl
so I assume it's
me. Thanks in advance!
Jaime Cook
539 Kathmere Road
Havertown, PA 19083
610-789-6179 (H)
443-466-3138 (C)
cook_jaime(_at_)yahoo(_dot_)com
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--