Re: Perl - Newbie question

dbaplusplus_at_hotmail.com wrote in news:1149627946.026944.302980 @h76g2000cwa.googlegroups.com:

> 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.
>
>

Just as you'd invoke any other command line utility - system("env > /tmp/my.env");
system("sqlplus login/password @mysql.sql");

BUT keep in mind that the new shell environment will likely NOT have current shell environmental variable values! Received on Tue Jun 06 2006 - 17:34:04 CDT