Monthly Archives: March 2007

ORA-06552: PL/SQL: Compilation Unit Analysis Terminated

Database, Programming

Today I received a strange error from Oracle, for what appeared to be no good reason:

  1. ORA-06552: PL/SQL: Compilation unit analysis terminated
  2. ORA-06553: PLS-320: The declaration of the type of this expression is incomplete or malformed

I received the error when attempting to create a trigger on a newly created table. I could create triggers on other tables without any errors, however on the new table – it would error every time.

The table definition included a column named timestamp with the data type timestamp. Oracle was happy enough for me to create the table, however it refused to let me create a trigger on the table with a column name over lapping a reserved word.

The solution was simple, renamed the column in question to use a non-reserved word and everything continued as normal. I must say though, I think it is strange that it would let me create the table using the reserved word in the first place if it was going to complain about me using other standard Oracle features which would error as a by product of the reserved word.

1 Vs 100 Game Show

TV

Eddie McGuire is back hosting the latest Channel 9 game show offering, 1 Vs 100. The new game show goes something like this, someone is picked as the one. Once selected, they have to answer a series of questions and so do the mob of 100 opponents.

The contestant is also given three chances or from the millionaire days, three life lines. Each of the changes or life lines can only be used once each, just like Who Wants To Be A Millionaire. The twist on the chances or life lines this time is that they all involve the mob in some way:

Ask the mob
Two of the mob are singled out who have a correct and incorrect answer. Each mob member can tell the contestant why they chose that option and the contestant can also discuss their choice. Since there are only two of the mob selected, this in effect acts like the 50/50 from the days of Who Wants To Be A Millionaire.
Poll the mob
Polling the mob will tell the contestant how many of the mob voted for each of the three options
Trust the mob
The contestant rests their game show fate into the hands of the mob. Whatever option the mob has the most votes for, is the option that is selected on behalf of the contestant and they don’t have a choice but to see the decision followed through.

After successfully answering a question, the answers from the mob are revealed as well; at which point everyone with an incorrect answer are eliminated from the following round. After the results of the dwindling one hundred opponents are revealed, the contestant then gets a choice to complete the game and leave with the money he or she has accumulated or play on.

The decision making process of the contestant was the most painful point in the entire show, where the mob are just yelling at the contestant trying to convince he or she to play one more round. Of course, they are all waving their hands and gesturing, yes, come on, just one more round. This went on and on for far too long in my opinion and it has no real bearing on the game; its as if it was there to simply amp up the noise level and the crowd a little for the sake of it.

Overall, it was a pretty reasonable game show I suppose. 1 Vs 100 bears striking resemblance to Who Wants To Be A Millionaire on many fronts, however the one which it doesn’t complete on from what I noticed was the difficulty of the questions. It seemed as though they were considerably easier than what you’d expect on millionaire – then again, it is a different show, which should draw different contestants; so that is probably ok.

On a side note, does anyone else think it is inappropriate for Eddie McGuire to be hosting a game show when he is the Chief Execute Office of one of Australia’s largest television networks? I was quite shocked in February 2006 when he was appointed as the CEO of Channel Nine and to see him still hosting a game show; it just seems wrong.

Clean Sweep

Sport

Towards the start of 2006, I was pleased to find out that some of my work colleagues enjoyed playing squash. It wasn’t long after I found about their squash habits that we started organising semi-regular casual games. That whole experience was a bunch of fun, as trying to play squash like tennis really didn’t work well – so the process of learning a new game and the techniques behind it was great.

About six months ago, I decided it was about time I joined one of our local Gold Coast squash clubs. Without a lot of thought or discussion about the matter and based on one of the guys recommendations – I joined the Robina Squash Club.

Robina Squash Club uses the squash facilities which are associated to Bond University. Bond University have two good condition, glass backed courts with air conditioning. Apparently there used to be four courts, however two of them were turned into fitness rooms to extend the university gym facilities.

The new squash season (my second) recently commenced at the Robina Squash Club and I’ve been having a blast. Since I first started playing in the squash fixtures six months ago, my game has improved out of sight – to a point where I’m regularly challenging or winning games.

This evening was quite a milestone, as I won my first match against one of the strongest players in my group four sets to nil! My competitor, Tony, would hit the black of the squash ball if he could. He just loves hitting the ball hard and I do mean hard. The last time I played Tony, we drew two games each and he pipped me by a few points to claim the win over all. This week, I managed to snatch all four sets off him – if only by a point or two; I still won all four sets. It was quite an accomplishment and I’m pretty pleased with my progress over the last six months; hopefully the next six will be just as good.

For those looking to play squash in the Gold Coast region, you can contact:

Robina Squash Club
University Drive
Robina QLD, 4226
0427 627 229

WordPress Security Vulnerability

Blogging, Programming, Software

Some period of time after WordPress 2.1.1 was released, one or more of the WordPress servers was breached and the attacker edited the PHP source of a handful of files within the 2.1.1 download files.

The WordPress crew were fast to react to the news and have released a statement, which states that they have boycotted the release of WordPress 2.1.1 as they don’t know exactly when the attacker breached their servers.

The WordPress development team have also released WordPress 2.1.2 which is recommended as a mandatory upgrade if you previously upgraded to WordPress 2.1.1 within the last week or so. I would expect that in the coming weeks, we’ll see some new security initiatives from the WordPress team to try and reduce the chances of this happening again in the future.