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!
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!