-
Archives
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
- October 2006
- September 2006
- August 2006
- July 2006
- June 2006
- May 2006
- April 2006
- March 2006
- February 2006
- January 2006
- December 2005
- November 2005
- October 2005
- September 2005
- August 2005
- July 2005
- June 2005
- May 2005
- April 2005
- March 2005
- February 2005
- January 2005
- December 2004
-
Meta
Tag Archives: PL/SQL
Learning How To Scale An ASP.NET Application
For the last nine months, the development team at Stella Hospitality Group have been working on integrating a new piece of software into the enterprise. Throughout that process, we’ve come up against various stumbling blocks and subsequently learned how to … Continue reading
Oracle Dynamic SQL Using The DECODE Function
When developing most applications, you end up having to interact with a database. If you’re application is large enough and warrants the design and effort, it will no doubt be tiered as well. If your application is tiered, one of … Continue reading
Storing Time Information In Oracle
I recently had a requirement to store a time within Oracle, not a timestamp or a date – just the time. As it turns out, storing just the time information in Oracle isn’t something you can do without a little … Continue reading
ORA-06552: PL/SQL: Compilation Unit Analysis Terminated
Today I received a strange error from Oracle, for what appeared to be no good reason: ORA-06552: PL/SQL: Compilation unit analysis terminated ORA-06553: PLS-320: The declaration of the type of this expression is incomplete or malformed I received the error … Continue reading
ORA-06502: PL/SQL: numeric or value error
Today I came up against a very frustrating problem when writing some Oracle PL/SQL stored procedures and functions: ORA-06502: PL/SQL: numeric or value error When I first wrote the stored function in question, I was using VARCHAR2 types for storage … Continue reading