Considering that you are familiar with the Korn shell, there's no reason to give up on that knowledge. Use nested here documents, one in Perl, the other in the shell (untested code):

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

... do something with $output ...
[download]