Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

XMLType - extract multiple nodes???

Status
Not open for further replies.

msf11

Technical User
Apr 10, 2003
15
US
Hi,

I'm trying to select mulitple records from an XMLType file. Here is my code:

SELECT
report_date,
EXTRACTVALUE(tr.trx_data , '/trx-report/body/line/external-id/text()') "External ID"
FROM
TRX_REPORT tr

The error i get is:
ORA-19025: EXTRACTVALUE returns value of only one node

Is there a function that will select multipe nodes and output each node as a single record?

Thanks for the help!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top