Storing your Scripts in the XMLDB Repository
Posted on August 2, 2008
Filed Under Howto, Oracle, XMLDB, XSQL, XPath, XQuery | 1 Comment
The underlying structure of the XMLDB repository is a blob, but why not…? The following code was once demonstrated by Mark Drake in May on the OTN XMLDB Forum. It is a very useful alternative way to store some of our code / scripts…
declare res BOOLEAN; begin res := dbms_xdb.createResource('/public/q1.xqy','My Xquery'); commit; end; / SELECT xmlquery(xdburitype('/public/q1.xqy').getClob() passing OBJECT_VALUE returning content) FROM MY_XML_TABLE /
Fill in “My XQuery” or else, with your code or statements. Secure it via XMLDB’s ACL security options and “voila” your own script repository, amongst others, maintainable via WebDAV.
Portugal here we come!
Posted on August 1, 2008
Filed Under General | Leave a Comment
I am off. It’s time for a decent holiday. Portugal here we come.
See ya / Obrigado
![]()
OOW 2008 Content Catalog has been updated with Oracle Mix Winners
Posted on July 31, 2008
Filed Under General | 1 Comment
Triggered by Flavio’s blog post “and the winner is…” I checked if the other Oracle Mix winners were now also listed in the Content Catalog and could be scheduled via the Schedule Builder
and YES they are…(at least those who have confirmed the presentation - can’t find Richard Foote yet…) !
Besides Flavio’s presentation, I also registered myself now for Chris Muir’s presentation: “Back to Basics: Simple Database Web Services Without an Application Server (S301704). One of the Oracle Open World Oracle Mix Winner session lists can be found here: Oracle Open World Session Winners
Anyway, have a look via your Oracle Open World Schedule Builder
![]()
Setting Up an XMLDB Performance “Baseline” Environment (Part 02)
Posted on July 30, 2008
Filed Under 11g, Binary-, CLOB-, Object Relational Storage, General, Howto, Performance, XMLDB | Leave a Comment
Hmmm, still busy to setup a baseline environment to do some serious XMLDB performance / architecture testing. I am almost now on the point were I really can start, but until now I ran into a lot of issues… It also told me that the mediawiki dumpfile is good set of XML data to work with. A lot of variance is build in. I hope I won’t encounter too much more issues though…
Riding the Wave - How to beef up APEX…?!
Posted on July 29, 2008
Filed Under APEX, XMLDB | Leave a Comment
Yep, I am having a little fun here, but while every APEX enthusiast out there is promoting APEX, I thought: lets ride the wave… One you should schedule for Oracle Open World and I saw even made it on David’s APEX list
I am In…
Posted on July 26, 2008
Filed Under General | 1 Comment
As Nial said it, I am honored and very proud, because this year wasn’t “easy”. It was very though and I helped this year to judge 400 other presentations, so I know. Probably it is never easy, but the competition this year was huge. So making the first step in such a context, with such a “strange” field (XMLDB), makes me extra proud.
I made the first hurdle…
UKOUG 2008 - Speaker Confirmation
Dear MarcoThank you for submitting your abstract “Having Fun with the XMLDB Protocol Server”, to present at UKOUG 2008, in Birmingham.
I am delighted to confirm that you been selected for inclusion with the program to present on Tuesday 2nd December.
Kind regards,
Aimee Kimerling
Agenda Project Manager
Still have to do some work on the presentation because I was also asked to merge some of the content from the other presentation into “Having Fun with the XMLDB Protocol Server”. I guess an other title to reflect better the merged content is then also in order. So I am not there yet. I have to rewrite it and still keep it “light” for this year incentive to do more presentations that would appeal beginners.
Hopefully seeing you there this year.
Marco
