How can I invoke SQLPLUS within a perl script?

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: How can I invoke SQLPLUS within a perl script? by jorg (Friar) on Mar 30, 2001 at 00:49 UTC
If you mean sqlplus , the Oracle tool then you can invoke it through my $output = `sqlplus username/pwd @sqlfile.sql`(output of sqlplus is stored in $output) or you could do a system call as in `my $rc = system('sqlplus username/pwd @sqlfile.sql')`($rc contains the returncode of sqlplus) This is the approach you can follow to execute any system command, either backticks ``, or system().. Do a supersearch on these keywords to find more examples. Jorg "Do or do not, there is no try" -- Yoda	[reply] [d/l] [select]
Re: Re: How can I invoke SQLPLUS within a perl script? by Anonymous Monk on Mar 31, 2001 at 07:08 UTC
Thanks. How about using "here document" ? Something like: sqlplus username/pwd <<EOF some sql code... EOF I could not make it work.	[reply]
Re: Re: Re: How can I invoke SQLPLUS within a perl script? by jorg (Friar) on Apr 01, 2001 at 00:24 UTC
sure you would then do: `my $command= <<COMMAND; sqlplus / username/password @runthisfile.sql COMMAND` [download] then plug $command into the above described functions Jorg "Do or do not, there is no try" -- Yoda	[reply] [d/l]
Re: How can I invoke SQLPLUS within a perl script? by physi (Friar) on Mar 29, 2001 at 21:32 UTC
look at CPAN Moule DBI and a DBD::Oracle for it. Then you can make a connection to your Database from in your perlscript and then use sql- for your queries.	[reply]