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";

[download]
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.

In Section Seekers of Perl Wisdom