Skip to Main Content

Database Software

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.

XBRL support

User_HWHT9Mar 22 2009 — edited Oct 7 2009
I currently have the exercise of looking at the XBRL support within Oracle 11g. I'm neither a XBRL or XML DB expert; I note there is a large technical challenge of understanding XBRL, XML DB and XML in combination. I guess that's what I get paid for.

Our use case is we'll be receiving XBRL instance documents embedded in web services, which we need to validate and extract data to a legacy set of tables. The synchronous web service will then collate an XBRL instance document response, which may retreive data from a legacy set of tables, and in turn validate that structure before sending the response. Besides the web services we're hoping we'll be able to do most of the XBRL work within the database.

I think in summary it looks like the database can store the XBRL taxonomies and instance documents, as well as validate the XBRL instance documents and extract data via the usual XQuery facilities. I hope that's a fair summary? I'm not overly confident I can outline what the database can't do for us. Generating instance documents is one, though I'm thinking we can just do this programmatically. Maybe other readers can comment?

Thanks to [Marco Gralike |http://www.liberidu.com/blog/?page_id=241] 's website with XBRL references, I've been reading through the following OTN forum 540841 that among other things details a script used by Mark Drake for loading XBRL into the database. While the forum post is good, it does leave out what I think are essential details, such as examples of the Register-XBRL.xml, Register-KIS.xml files.

Given some searching I've seen the same script is more or less mentioned on Oracle Support in a bug report, which leaves me to believe we can obtain it from somewhere. Is anyone familiar with the script revealed in the OTN forum post and where I can retrieve it from?

Your thoughts and assistance appreciated.

Regards,

CM.

Comments

245446
.NET CF is not yet supported by Oracle 9i Lite, it's scheduled for partial support in the patch 5.0.2.8, which is due out September 15th, and full support in the new version 9.0.2 (they are changing the version from 5.X.X too 9.X.X so that Lite and the rest of Oracle is at the same version number) which is scheduled for December 1st...of course as we all know those dates can change.

Shaun
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 4 2009
Added on Mar 22 2009
8 comments
2,164 views