Re: How can I invoke SQLPLUS within a perl script?

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

Comment on Re: How can I invoke SQLPLUS within a perl script? Select or Download Code

Replies are listed 'Best First'.
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]