1 Reply Latest reply: Jul 16, 2013 4:15 AM by 1a456d4b-aaf9-4258-ac8c-4e7fad04e6f1 RSS

    XBRL Extension - loading/deleting instance?

    1a456d4b-aaf9-4258-ac8c-4e7fad04e6f1

      Hi,

      I have the XBRL Extension installed on Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production.

       

      I loaded a taxonomy (with loadSchema and loadLinkbase procedures) and several instances (with loadInstance procedure) without any problems. I can also delete an instance, but if I want to reload that instance, or another instance, using the same location I get:

       

      > EXEC DBMS_ORAXBRL.loadInstance('/test/istance1.xbrl', XMLType(BFILENAME(BASE_DIR, '/istance1.xbrl'), nls_charset_id('AL32UTF8')));

      ok

      > EXEC DBMS_ORAXBRL.deleteInstance('/test/istance1.xbrl');

      ok

      > EXEC DBMS_ORAXBRL.loadInstance('/test/istance1.xbrl', XMLType(BFILENAME(BASE_DIR, '/istance1.xbrl'), nls_charset_id('AL32UTF8')));

      ORA-20023: Delete Instance Failed: ORA-31001: Invalid resource handle or path name "/xbrl/xbrlsys/xbrlrc.xml"

      ORA-06512: at "XBRLSYS.DBMS_ORAXBRL", line 1506

      ORA-06512: at line 1

       

      What I did wrong? Is it a bug? I have the same issue if I execute DBMS_ORAXBRL.deleteFolder('/test') instead of deleteInstance. No problems if I change the location to '/test/istance2.xbrl' or similar...


      Furthermore, is it possible to update an instance without deleting it before?


      Thanks in advance for your help.