Skip to Main Content
Forums

SQL & PL/SQL

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-06553: PLS-307: too many declarations of 'XMLTYPE' match this call

vdsadhiOct 24 2019 — edited Oct 24 2019

Hello Experts,
We are using Oracle 12c 12.1.0.2.0.
 
  We are receiving a XML response from web API and trying to make it as table but getting the below error,

ORA-06553: PLS-307: too many declarations of 'XMLTYPE' match this call

  This is the query,

SELECT f.column_value    AS block_content,
  extractValue(value(f),'/name')    AS block_name,
  extractValue(value(f),'/ValueNode') AS RecordsDisplayCount
FROM TABLE( XMLSequence( EXTRACT( XMLType('<?xml version="1.0" encoding="utf-8" ?>
<rsp stat="ok">
<applicationlist>
<application>
<appId>35H3Z5JJIM</appId>
<name><![CDATA[Sample Application]]></name>
<createDate>2019-24-01T08:14:28.000+0000</createDate>
</application>
<application>
<appId>IZ2UGLWP98</appId>
<name><![CDATA[Management Application]]></name>
<createDate>2019-24-02T07:40:09.000+0000</createDate>
</application>
</applicationlist>
</rsp>',1), 'rsp/applicationlist' ) ) ) f;


Please help us to solve this issue. What is wrong in the above query and what are all ways to achieve it?

Thanks in Advance!!
Regards, Lakshmi
This post has been answered by padders on Oct 24 2019
Jump to Answer

Comments

Post Details

Added on Oct 24 2019
4 comments
3,476 views