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.