I have had the chance to revisit one of the scripts I had taken over from a consultant earlier due to the need of a new feature.
The feature was inserting a complete email into an Oracle CLOB field. This was no problem using DBI.
The solution was hastedly made and was followed by a refactoring and some addtions to the POD.
Perl Rocks!
I really enjoy working with Perl, Unofortunately I had to fall back to a varchar2(4000) sized field due to problems with the OLEDB driver we use for our VB.NET client which cannot read CLOBs.
Anyway rolling back was no problem either, but since I might run into size problems I parse the mail before inserting it and again I was amased by the ease of writing a simple parser in Perl.
So implementation, followed by refactoring and documentation and test...
Nothing like a success in the morning...
