ORA-19112: error raised during evaluation: FODC0003, Function stability not defined (Doc ID 1638680.1)

Last updated on MARCH 23, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Error while selecting XML data using XMLTABLE (using XMLTYPE for locating the xml file) and function:

SQL> declare
 2    Type Folders is Table of VarChar2(256);
 3    XMLFolders Folders := Folders('/public/temp/');
 4    v_Return boolean;
 5    myXML XMLType;
 6    selectValue varchar(10);
 7  begin
 8    myXML := XMLType('<a id="2"><b><c>test</c></b></a>');
 9    v_Return := DBMS_XDB.createFolder( XMLFolders(1) );
10
11    v_Return := DBMS_XDB.createResource(XMLFolders(XMLFolders.Last) || 'my-xml' || '.xml', myXML);
12
13  Select TIR.TestItemId into selectValue
From
14   15    (Select XMLType('<path value="' || '/public/temp/my-xml.xml' || '"/>') as ResourcePath From Dual) X,
16    XMLTable('for $mydata in fn:doc(xs:string($ResourcePath))/a/b/c
17              let $mysubdata := $mydata/../..
18              return <xyz id="{$mysubdata/@id}"/>'
19              Passing X.ResourcePath.extract('/path/@value') as "ResourcePath"
20              Columns TestItemId VarChar2(32) Path '@id') TIR;
21
22    DBMS_Output.put_Line('Result from XML - ' || selectValue);
23  end;
24  /
declare
*
ERROR at line 1:
ORA-19112: error raised during evaluation: FODC0003, Function stability not
defined
ORA-06512: at line 13


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms