Skip to Main Content
Forums

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how get value from xml response ?

user7340885Jan 27 2021 — edited Jan 27 2021

hi every one
i am using oracle webservice to call oracle reports from procedure
it work fine and this is response xml docment i want get the job id from this
xml.png<?xml version="1.0" encoding="WINDOWS-1256"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<SOAP-ENV:Body>
<ns1:runJobResponse xmlns:ns1="urn:oracle-reports-rwclient-RWWebService" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<return xsi:type="xsd:string"><?xml version = '1.0' encoding = 'ISO-8859-1' standalone = 'yes'?>
<serverQueues>
<job id="92" queueType="current">
<name>D:\reports\bl_prt_inv.jsp</name>
<type>report</type>
<status code="1">انتظار في الطابور</status>
<owner>RWUser</owner>
<server>reportserv1</server>
<destination>
<desType>file</desType>
<desFormat>pdf</desFormat>
</destination>
<timingInfo>
<queued>26/01/2021 07:34:28 م</queued>
<started>26/01/2021 07:34:28 م</started>
<finished>26/01/2021 07:34:28 م</finished>
</timingInfo>
</job>
</serverQueues>
</return>
</ns1:runJobResponse>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

i am tri to use this
select id from testxm,
xmltable( '/serverQueues/job' passing testxm.xmfile
columns id varchar2(100) path '@id') xml_tbl ;
but it not work
any idea
regards ............
This post has been answered by cormaco on Jan 27 2021
Jump to Answer

Comments

Post Details

Added on Jan 27 2021
#forms, #moved-from-devops, #oracle, #pl-sql, #plsql, #reports, #xml
4 comments
777 views