Colin,
I reviewed the 2nd reference in your orig post.
# we assume this package already exists
my $plsql = q{
CREATE OR REPLACE PACKAGE plsql_example
....
I don't believe the author actually meant that $plsql could be prepared and
executed. When dealing with code stored in a database some means to
communicate what the stored code looks like is always required. Still this
has me wondering, because I can execute multiple statements from files with
.sql extensions. Perhaps some one reading this knows of clever work-around?
David