Generating XML from SQL & PL/SQL and Code Instrumentation

From time to time you’ll have to represent your data stored in a database in an XML format, eg. to exchange it between systems, to send it to external parties, etc.
In an article on All Things Oracle I give an introduction on how you can generate XML documents:

 

Another interesting article from my colleague Jan Leers is about Code Instrumentation.

Whenever we execute a procedure, it’s out of our hands. We expect it to do what it was designed to do, but what if it doesn’t?
What if it takes a lot more time then expected?
All kind of questions start to arise:

  • Is it almost finished, should I wait just a few more minutes?
  • Is it trapped in an infinitive loop? Or are my queries running slow?
  • Can I safely kill it? Or did it already commit some changes and should I reverse them?
  • Which job should I kill, is this mine?

Want to find out how you can answer these questions?  Read his article on All Things Oracle

Seminar: Oracle and Reporting(Mechelen 08/11/2012)

Do you have one or more applications on top of on Oracle Database?

Do you want to show this data in documents and/or reports?

Did you know you don’t have to make a big investment in a BI solution to create attractive letters, orders, invoices or lists?

But which reporting tool, from a long list, is the best solution?

After many years of using and testing different tools, we will show and share our experiences of our preferred reporting tools:

  • Oracle Application Express
  • Oracle Reports
  • Oracle BI Publisher
  • JasperReports
  • SQL Word
  • Eclipse Birt
  • PL/PDF
  • DocuFy

We’re going to demo and compare those tools so you can learn the possibilities, advantages/disadvantages, …
Of course we’re also taking the learning curves and prices in count, so you can find out the best solution for you and your company.

More info and Registration(Dutch)

Why should you attend Oracle OpenXperience on 25 October in Brussels?

Because it’s there that you’ll find out how your organisation can benefit from Oracle’s new technologies!

Are mobility and the cloud opportunities for your organization or threats to its security?

Can applicationshardware and software really work together?

Is Oracle 12c a sensible investment?

Is drowning in (big) data unavoidable?

How can business intelligence become an integral part of IT structure?

If at least one of these questions rings a bell, you should attend Oracle OpenXperience. It’s where 10 of Oracle’s most valued partners will present their (local) views on today’s IT challenges and Oracle’s solutions for tackling them. It’s where you’ll discover the practical approach of our partners, in 12 sessions divided into 3 distinct tracks.

For the bigger picture, don’t miss the keynote sessions. Mario Derba, Regional Vice President Systems Sales, South Europe, will share his insight on Oracle’s worldwide strategy. After lunch, famous Belgian innovator, consultant and strategic influencer Jo Caudron will talk about current trends and how they affect IT and your business.

Where?
The Event Lounge
Generaal Wahislaan/Boulevard Général Wahis 16/F
1030 Brussels

When?
Thursday 25 October 2012
10.00-18.00

Register here

All things Oracle: Generating XML from SQL

Did you ever needed your table data in an XML format?
Well, it isn’t that hard…  Oracle provides several ways to generate XML, in both SQL and PL/SQL.

I wrote an article on All Things Oracle in which I explain step by step how you can generate XML from table data.
In this first part I show you some SQL functions which are easy to use.  Check it out!

BeNeLux Architectural Networking Event at Oracle Open World 2012

The events at Oracle Open World are rolling in.  Here’s a very interesting one in case your from the Benelux(Belgium, The Netherlands and Luxemburg): BeNeLux Architectural Networking Event.

 

Target audience
Anybody who would like to discuss projects, architectures, product combinations, or technical issues is welcome to attend.

There will be some experts that will help you with your questions, among them: Wim Coeckaerts (Sr. Vice President, Linux and Virtualization), Jeff Davies (Sr. Principal PM Product Manager, SOA & BMP), Scott Howley (VP, Middleware), Xavier Verhaeghe (VP Emerging Technologies & Security) and many more(see the event page for the list).

In case you want to talk to us, iAdvise will also be present.

Oracle Forms: upgrade…modernize…integrate

iAdvise already did several presentations and seminars about Forms and Forms Modernization.
And it’s good to see that companies get the messages we are talking about.

We’ve visited a customer who still had some questions on the future of Forms.
They received complaints of users that the UI isn’t “sexy” enough, but besides that there’s nothing “wrong” with the application.

That’s why we told them there’s no need to migrate to another technology.
The demos we did about upgrading, modernizing and integration and of course the statement of direction of Oracle(Oracle Forms will not desupported) showed that we are right.

Now they’re planning the upgrade from Forms 10g to 11g.
After that they’ll take a look at how they can modernize the application(look&feel) and how they can integrate with their other applications.
That’s the way to go!

If you want to read more about our view on Oracle Forms, check out the article “What’s your choice for Oracle Forms” on All Things Oracle.

Oracle Open World – Larry’s keynote: some announcements

Larry talks first about Fusion Apps.
After a controlled test period, it’s now officially available.

And now for really the first announcement…
Larry Ellison: “Everybody has a cloud, we too need a cloud”
So here it is Oracle Public Could.
Great to see Apex is strongly supported.

You can move your application and data from your datacenter to the cloud and back without a problem.
The Oracle Cloud is based on industry standards(Java, XML, Web services,…).
Pricing is based on monthly subscription, and that’s all, no extra licenses.

A second announcement: Oracle Social Network.
Collaborate, share, application integration, BI Navigation, …
He even gave a live demo of the Oracle Social Network.

Oracle Open World starts today!

And I’m the lucky one that is in San Francisco!

So, what’s on for today…
Wake up, breakfast, presentation rehearsal and off to Moscone to register.

And we kick of with ADF EMG sunday.

This should be interesting when you take a look at that list of speakers.

And of course later on today the keynote by Larry Ellison.
Very curious about that!

Like I said before, tomorrow is my own presentation:

  • Session: What’s Your Choice for Oracle Forms: Modernize, Upgrade, Integrate, or Migrate? (session id 08262)
  • Time and place: Monday, 12:30 PM, Marriott Marquis – Golden Gate A

This will be an interesting session for all Forms developers and users!

In case you’re not attending Oracle Open World, follow this blog and the iadvise twitter for regular updates from OOW.

If you want a complete overview from people attending Oracle Open World, come to the OpenXperience day on 21 October in Diegem, Belgium.
Visitors of Oracle Open World will bring you the most interesting information and hot news.