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

8-)

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

8-)

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…

Read more

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

Read more

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 Marco

Thank 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

Next Page →