Consuming Web Services using PL/SQL…

 

I have a couple of soultions for consuming web services using PL/SQL.

The problem has always been that every so often the web services referenced by these articles disappear, so I have to modify the articles to use a different web service. Well, I got sick of people pulling the plug on their web services, so I created one of my own that just adds two numbers together. The articles now reference that web service, so it should be a little more stable.

In the process of doing the alterations to the articles I had a lot of trouble with UTL_DBWS. I’m not at all convinced by this solution. On the surface it seems OK, and it certainly seemed to be OK in 10gR2, but it seems very flaky in 11gR2. The old 9i method seems a lot more stable, and you have complete control as you are doing everything yourself.

Of course the real problem with web services and PL/SQL is people look at their WSDL file and then mail me asking what the hell they do with it. I think I’m going to start suggesting they pass it to the Java guys and handle it in the middle tier. Problem solved. :)

Cheers

Tim…

Touchdown in Zagreb, Croatia…

 

When I left Birmingham and it was a warm and sunny. I arrived in Zagreb, Croatia and it is wet. The taxi driver apologized for the weather, but I told him this feels more like home than home does. :)

The flight went OK. I had a 4 hour stop in Frankfurt, but I used this new fangled interweb thing to keep me occupied. It’s fun, but I can’t see it catching on.

The second leg of the trip had a bit of turbulence on take-off and landing, but apart from a few quick flashbacks to trans-atlantic nightmares, I was fine. I had a little phone drama once I landed, centered around the fact I couldn’t find it. Once I got to the hotel I emptied my rucksack and found it hiding in a side pocket. Pesky bags with their handy side pockets…

The taxi driver gave the the heads-up on a few bits of the local lingo. I’ve added enough words to my vocabulary to make myself look completely stupid tomorrow.

Tomorrow morning I start a 2-day PL/SQL class for Oracle University. It should be easy to get to as it’s in the same hotel I’m staying in. The only thing I’ve got do before the class is sleep and iron 2 shirts. The ironing is praying heavily on my mind. I should have stipulated “crumpled appearance” in the contract.

Cheers

Tim…

Oracle Database File System (DBFS) PL/SQL APIs…

 

My previous article discussed the DBFS. This article gives an overview of the PL/SQL APIs for managing and interacting with the DBFS.

There’s a lot in there, so this is just skimming the surface.

Cheers

Tim…

A quick thank you…

 

Just a quick note to say thank you to everyone involved in making the 2-day PL/SQL workshop in Utrecht happen last week. Thanks to Miracle Benelux for staging the event, to Anjo for inviting me and to Annette for organizing everything, including Anjo. :)

Of course the biggest thanks go to everyone who came to the workshop, because without them it wouldn’t happen. See you all soon. :)

Cheers

Tim…

Slovakia Day 2

 

I’m not nervous about flying, but I am nervous about being late for flights, so day 2 was a complex day for me. The plan was to teach from 9:00-17:00 then go straight to the airport and leave. Having the deadline for the airport in the back of my mind all day meant I was a little on edge. Even so, it all went pretty well.

Anyone who’s seen my conference talks knows I do quite a lot of demos. Well the 2 day workshops are crammed full of them. I more or less try to prove every sentence I say with a demo. Of course, this means things inevitably go wrong from time to time. I had one demo hang, and Enterprise Manager decided not to work, so I had to miss out another demo. Overall though, things went pretty smooth and by the numbers.

I’d like to say thanks to everyone who came to the session and thanks to the people at Oracle that make it possible, especially Stefania Panaite.

So I’m home now and I have 4 days to prepare for the next two conferences (ORCAN and OUGF) that happen back-to-back. I’ve got two new talks to rehearse, one I’ve not even written yet, and one 60 minute talk I’ve got to somehow turn into a 30 minute version. Don’t even mention the paperwork I have to do. :)

Cheers

Tim…

Slovakia Day 1…

 

That’s day 1 over as far as teaching is concerned. The audience is quite a diverse mix. Everything from 6 months to 10+ years of Oracle experience and from variety of countries too. I’ve even got a member of Oracle staff in the group. I wonder if he’s a spy… :)

It’s always dangerous to start getting too analytical about the lessons part way through course, so I will leave that until after I finish tomorrow.

I probably should go out and do some sightseeing now, but I think I’ll probably get some food and come back to the hotel and collapse. :)

Cheers

Tim…

Slovakia Day -1

 

I got to Slovakia with no major trauma.  I also had enough time to have a quick look round. There are some photos here if you are interested. As always, I used the shotgun approach. Several shots of each scene in the hope something would come out looking OK. :)

Not sure if I’ll have time to do any more looking around. The schedule is pretty tight for the next 2 days and I leave straight after finishing the second day. Better than nothing though.

It’s a Sunday so the streets are pretty quiet except for tourists.

Cheers

Tim…

FTP from PL/SQL: An Update…

 

I’ve put a new version of my PL/SQL FTP API (ftp.pks, ftp.pkb) live today. The changes are also reflected in the associated article.

Over the years a number of people have contributed suggestions and actual code for it. Where possible their names are reflected in the amendment history.

Cheers

Tim…

OCA PL/SQL Developer and stuff…

 

Today has been a bit of a rare day…

I hurt my back last night at Karate. I managed to get in on a cancellation at my osteopath, so off I went this morning to get everything straightened out.

I left the osteopath just in time to get to the Prometric test center down the road to sit the “Program with PL/SQL (1Z0-147)” exam, which I passed. The exam was pretty easy, but then I have been doing this stuff for 14 years. I sat the “Introduction to Oracle: SQL and PL/SQL (1Z0-001)” as part of my Oracle 7.3 OCP, so I guess I’m now an “Oracle PL/SQL Developer Certified Associate”.

The reason for doing this is I quite fancy doing the “Oracle Database 11g: Advanced PL/SQL” exam, currently in beta, to get the “Oracle Advanced PL/SQL Developer Certified Professional”. The OCA PL/SQL Developer is a prerequesite. I’ve been teaching most of the content of the “Oracle Database 11g: Advanced PL/SQL” this year so it shouldn’t be a problem. I just don’t know if I’ll have time before I hit the road, and the beta period will be over by the time I get back…

What made the whole day a bit more problematic, was I had a Diabetes clinic appointment today and I wasn’t allowed to eat before it, so I was really hungry. My appointment was at 15:30 and I hadn’t eaten since about 17:00 the previous day. Back pain and hunger aren’t the normal things you expect to deal with during an exam. Never mind, it’s sorted now… :)

By the way, I might be doing a couple of talks at the Swedish Oracle User Group in December (10th-11th). Nothing definite at the moment. I’ve been invited, but it’s all in the ether. The world tour continues… :)

Cheers

Tim…