Category Archives: Database
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
PostgreSQL Dynamic SQL & Quote_ident Gotchas
PostgreSQL provides two useful functions to aid in the safe development of dynamic SQL: quote_ident The quote_ident function accepts and returns a text type. Whatever text you pass into quote_ident will be suitably escaped such that you could safely use … Continue reading
WordPress Plugin: Kottke Style Archives
Are you sick of seeing WordPress archives that stretch the length of your arm? If you are, then you might have just found the next best thing to sliced bread! The Kottke Style Archives plugin is a WordPress archives plugin … Continue reading