APEX

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!

ORA-31013: Invalid XPATH expression in APEX_WEB_SERVICE

xarg-XrcMar 30 2014 — edited Apr 7 2014

Hi,

I am having some trouble using the APEX_WEB_SERVICE.PARSE_RESPONSE_CLOB function.

I am calling a reportin in BI Publisher, to obtain the value of CLOB001 column of the Apex Collection function.

declare
  l_clob CLOB := NULL;
begin


  l_clob := APEX_WEB_SERVICE.PARSE_RESPONSE_CLOB (
  p_collection_name   => 'APEX_BI_REPORT',
  p_xpath             => '//downloadReportObjectReturn',
  p_ns => 'http://xmlns.oracle.com/oxp/service/PublicReportService');




END;

The output XML clob with result looks like (turncated):

<downloadReportObjectResponse xmlns="http://xmlns.oracle.com/oxp/service/PublicReportService"> <downloadReportObjectReturn>UEsDBBQACAAI........

I am not sure where I am going wrong in the p_xpath expression. Any help appreciated. Thanks.

Application Express 4.2.2.00.11

Message was edited by: xarg-Xrc

This post has been answered by J-Lig on Apr 4 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 5 2014

Added on Mar 30 2014

#apex-discussions

6 comments

3,066 views