I'm not sure what the need for Toad is. Doesn't the use of such a tool greatly restrict the usefulness of testing since it isn't automated. What is Toad bringing you that can't just as easily be done with direct DBI connections and if need be ` interaction with SQL*Plus? Toad's strength is as a GUI tool for a user to interact with Oracle. Scripting... now that's SQL*Plus' turf. I'd look into DBI::Oracle
and one of Perl's testing
being my weapon of choice.
Also... Where's the pod?
AFTERTHOUGHT: The fact that you've gotten Toad to work means that DBI::Oracle can as well, cutting out the middleman.