For a perl solution see DBI and DBD::Oracle. A non perl solution would be sqllrd

If you're new to perl see the tutorials section (including Getting Started with Perl and Database Programming) of this site, and http://learn.perl.org.