in reply to (OT) DBD error Ora-12154

I don't know about your setup, but we need this line in ours:
#set env variable for database $ENV{'ORACLE_HOME'}="/path/to/oracle/install";
Try putting something like that near the start of your program.

---
It's all fine and dandy until someone has to look at the code.