ORA-01801: Date Format is too Long for Internal Buffer

Dominic Delmolino on 27 March 2012 with 0 comments

Oracle 10.2.0.1 (I know, version out-of-date) on Windows 2003: The other day one of my stored procedures error’ed out with: ORA-01801: date format is too long for internal buffer somewhere near a line in which I was doing the following assignment: d := to_char(c.date_field,’YYYYMMDD’); Where d is of type varchar2, and c is a row from a cursor for loop,… Continue Reading →

Applied Rapid Development Techniques for Database Engineers

Dominic Delmolino on 31 January 2012 with 2 comments

This article is based on the webinar delivered on 22 Nov 2011. You can read the full article below including the Q+A or: Download a PDF version Watch a video recording: Applied Rapid Development Techniques for Database Engineers In this article, Dominic Delmolino describes his experience in implementing a rapid refactoring and professional schema management process using standard software development… Continue Reading →