Perl - Newbie question

I know Perl has a DBI interface for Oracle, but my question is not about that interface. My question is how to invoke sqlplus command line interface from Perl scripts. My perl script is doing some other things already and I want to invoke some sql and Pl/SQL code.

For example, in Windows .bat file or UNIX .ksh:

Sqlplus login/password @mysql.sql

Or in UNIX ksh:

Sqlplus login/password << !
Select * from test;
Declare
Begin

    /* some PL/SQL CODE */
End;

!

How do I do same in Perl. I did search on Google but always found information on DBI interface, but not on what I am looking for. Received on Tue Jun 06 2006 - 16:05:46 CDT