Re: Perl - Newbie question

ianal Vista wrote:
> 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!

Thanks, that is a good starting point for me. Received on Tue Jun 06 2006 - 19:30:35 CDT