scott's blog

I was recently helping a colleague troubleshot an odd Oracle error in a pl/sql block he was writing. The error he received was:
ORA-06553: PLS-320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 3, column 123
And of course, line 3 held nothing interesting in relation to the error.

Last week our VOIP team upgraded our Cisco Call Center server for 7.x to 8.x. This move required the migration of the database from its previous MSSQL server to an IBM Informix database. For a while now, our business intelligence department has reported off of the call information recorded in this database to gather statistics about the call center’s performance.

After years of dealing with software companies you would expect that I would have grown callus to the way of things. The general lack of planning and design that many put into their products still astounds me. The lackadaisical approach to maintenance and product enhancements confounds me. Why do we purchase and implement products with such obvious over site?

Currently we are in the process of setting up Oracle Identity Management at the University. 3 databases are being configured for development, testing/qa, and of course production. Our other 15+ instances are running RHEL4 64bit with Oracle 10.2.0.4, so this will be the first RHEL5 64bit install we've done for Oracle.