Tag Archives: pl/sql

PL/SQL White Lists in Oracle Database 12c Release 1 (12.1)

I’ve been playing about with the ACCESSIBLE BY clause to create PL/SQL white lists in Oracle 12c. Here’s the article I wrote about it. PL/SQL White Lists Using the ACCESSIBLE BY Clause in Oracle Database 12c Release 1 (12.1) There seem to be some discrepancies in the documentation*, which I’ve highlighted in the article. Not [...]




WITH Clause Enhancements in Oracle 12c…

After doing a number of 12c installations, I decided it was time to write something new. I figured I’d pick something easy to start off with, so here is the first thing off the press. WITH Clause Enhancements in Oracle Database 12c Release 1 (12.1) Over the last year I’ve heard a few speakers talk [...]




Why is it easier to get things to work at home?

I’ve been grabbing a few minutes here and there over the last couple of work days trying to get something working with no joy. I this case it is a DAD entry in the “dads.conf” file on the OHS running as part of 11gR2 Forms & Reports Services on WebLogic 11g (10.3.6). I started to [...]




HTML with Embedded Images from PL/SQL…

Someone asked me a question about generating HTML with embedded images from PL/SQL and my answer started to spiral out of control, so I figured I’d just write it as an article. HTML with Embedded Images from PL/SQL Cheers Tim…




Advert: PL/SQL Masterclass Updates…

This month I’ll be doing some PL/SQL Masterclasses for Oracle University. The following dates have been confirmed: Singapore (14-15) Syndey (18-19) Melbourne (21-22) For more details contact Oracle University here. Originally there was an extra session in Hong Kong, but this has now been cancelled. In November the following dates are scheduled: Bulgaria (22-23) Serbia [...]




Advert: Asia Pacific PL/SQL Masterclasses…

It’s a little over a month before I start a run of four PL/SQL Masterclasses in the Asia Pacific region. Singapore (14-15 October) Syndey (18-19 October) Melbourne (21-22 October) Hong Kong (25-26 October) If you are interested, contact Oracle and get booked on. The details are here: APAC Seminars. Cheers Tim…




Oracle Database 11g: Advanced PL/SQL (1Z0-146)…

Lewis Cunningham recently mentioned on twitter that he had taken this exam and it reminded me I had been meaning to take it ever since it was announced in beta, but never actually got round to it. A quick search of my blog revealed it’s nearly 2 years since I mentioned I wanted to sit [...]




Consuming Web Services using PL/SQL…

I have a couple of soultions for consuming web services using PL/SQL. Consuming Web Services 9i UTL_DBWS – Consuming Web Services in Oracle 10g 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, [...]




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 [...]




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. Oracle Database File System (DBFS) PL/SQL APIs There’s a lot in there, so this is just skimming the surface. Cheers Tim…