Saturday, September 24, 2016

OSB 12C - XQuery- Error executing the transformation: {http://www.w3.org/2005/xqt-errors}FODC0002: Error retrieving resource "file://.xml"


After migrating from 11g to 12C , XQuery function  fn:doc started failing in one of the OSB project when trying to refer a static XML. After some research found out that it's happening only with XQuery version 1.0 not with 2004.

fn:doc("file://<filename>.xml")

Error Message:

Error executing the transformation: {http://www.w3.org/2005/xqt-errors}FODC0002: Error retrieving resource "file://<filename>.xml"

Solution:


Xquery implementation has been changed in 12C. So, to resolve this issue, give full path for the file

e.g.

fn:doc("file:///soa11g/soa1213/user_projects/domains/osb_domain/filename.xml") 


Posted by at
Labels: ,

2 comments:

  1. UnknownAugust 17, 2017 at 10:53 PM

    How to read file from one of projects

    ReplyDelete
  2. StevenHWickerNovember 25, 2021 at 6:45 AM

    Thank you for your articles that you have shared with us. Hopefully you can give the article a good benefit to us. Business Process Management Examples

    ReplyDelete

Subscribe to: Post Comments (Atom)