my $output = <<`EOT1`;
sqlplus.exe -s uid/pwd\@myserver <<EOT
select * from emp;
exit
EOT
EOT1

... do something with $output ...