Bob Showalter <[EMAIL PROTECTED]> wrote:
> jason corbett wrote:
> > What would I need to call SQL Plus into action for PERL?
>
> If you just need to execute SQL statements, use the DBI module
> and talk directly to the database.
>
> If you need to run existing sqlplus reports, use any of the
> standard facilities like system(), backticks, pipe open,
> fork/exec, etc. to call sqlplus from your perl script.
If using DBD/DBI is not an option, a better choice would be to open
sqlplus as a pipe stream, as in
open (SQLPLUS, "| sqlplus > $SQL_LOG")
or die "Can't fork process";
print SQLPLUS "$oraId/[EMAIL PROTECTED]";
print SQLPLUS " set heading off\n";
print SQLPLUS " set pagesize 0\n";
(etc)
You could then run some basic commands. You can use the same idea
to run plsql blocks.
HTH
Jeff
__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
