in reply to Running SQL*Plus from Perl

You should use a here doc. like so ...
... open( SQLPLUS, "|sqlplus /nolog" ) or die "Can't run sqlplus\n" ); print SQLPLUS <<SQL; connect user/pass@instance @myScript SQL ....

Plankton: 1% Evil, 99% Hot Gas.

Replies are listed 'Best First'.
Re: Re: Running SQL*Plus from Perl
by Jaki1980 (Novice) on Jan 14, 2004 at 22:54 UTC
    thanks Plankton. It worked!!!!