in reply to PERL DBI and oracle
Hi. It seems ur trying to use the statement handle in two unrelated places.
my $sth_subj; makes $sth_subj invisible to the execute_subject_query sub
that calls the execute method. Make *all* ur method calls in the same scope and
it should work.