Yolanda Winston wrote:
> I am running several scripts to runn SQL script in SQLplus....
>
> #exec 'SQLPLUS', 'username/password@oracle_sid "@h:\\banner\\tcu\\amake.SQL"
> $a1 $a2 $a3 $a3';
>
> This is logging onto oracle but it cannot find my sql script
>
> Does anyone know how to run a sql script in SQLPLUS using perl?
You could try this with system to get return code:
my @args = ('sqlplus', 'user/pwd@oracle_sid', '@h:\\banner\\tcu\\amake.SQL',
"$a1", "$a2", "$a3", "$a3");
my $return = system(@args);
or, with backticks to get script output:
my $output = `sqlplus user/pwd\@oracle_sid, \@h:\\banner\\tcu\\amake.SQL $a1 $a2
$a3 $a3`;
You have to escape the @ so that the backticks don't try to variable interpolate
an array that doesn't exist.
Hope that helps
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
