Icon from Iconspedia used under Creative Commons So, I’m back on track after yesterday’s detour to configure 11g and get it ready for the WebCenter schemas. I’m working off the WebCenter installation guide, by the way, Section 2.1.3 Create Schemas for Oracle WebCenter. Next step is to download and run Repository Creation Utility (RCU) which [...]
First, let me start off with a hearty thanks to John (@jpiwowar) for his help with my n00bism, a.k.a. Part 6 in this series. Also, thanks to those of you with DBA skills out there for not flaming me for my lack thereof. Part 6 was a bit of a disaster, but thanks to John and [...]
Today, I hit a roadblock in my ongoing project to create a WebCenter VM. I was all ready to get started with the WebCenter install. I found the installation guide and ran the installer. Then, I hit the prerequisites. Looks like I need to create the schemas first with the Repository Creation Utility (RCU), available [...]
Almost every application I’ve written in Application Express seems to end up with anonymous PL/SQL blocks. In the best practices document , this is called out as something to avoid doing. The document mentions reuse and reuse and manageability. Manageability includes things like running your logic within a debugger or in a Unit Test as [...]
I built a system internally a while ago and one of the most popular pages was one that showed a tree of data. We even got accused of caching the page because it was too dynamic and fast. Here’s what I did and what the output ended up like. In SQL Developer: In Application [...]
… in the Oracle blogosphere. Well, whether all these posts were ‘today’ depends on timezones, I suppose, but it’s today that I read them. My morning started with a read of this fine post by Cary Millsap. I immediately shared it around at work because Cary uses his typically strong way with words to explain [...]
It’s early days but I think I became the joint father of a bug report this week. This is bug number 9219636. SQL> CREATE TYPE INTEGER_ARRAY_T AS TABLE OF INTEGER 2 / Type created. SQL> SQL> CREATE TABLE V_SESSION_VALID ( 2 SID NUMBER , 3 SESSION_ID NUMBER NOT NULL, 4 CONSTRAINT [...]
Miracle Open World is on the horizon. Mogens and Annette talk about in this video (Oh, and be sure to watch until the end ). I think I’m supposed to be presenting at this one but I know places will be in short supply, so we’ll see. 14th-16th April at Legoland, Billund, Jutland, Denmark. Be [...]
Some features in this post require a Diagnostics Pack license. I think there a quite a few decent Oracle blogs around. There are links to some of them over there on the right. But by far my favourite this year has been Kerry Osborne’s. I think there are a number of reasons. 1) We have [...]
Oh, actually, there was one more non-technical post I’d forgotten. With such a rush between the course I taught in Bratislava, a quick trip to London for work (and some hairy performance problems) and UKOUG, I never got round to mentioning how the course trip went. First of all, I loved the brief look at [...]