I am facing issue while connecting to sqlplus in perl script. Following is my perl script code. It didn't execute properly & it take too much time to run very short sql.
$sql_return = `sqlplus -s user/password << SQL_END
set linesize 80
set pagesize 10
set heading off
set feedback off
WHERE ( ID= '$id');
$sql_return = trim($sql_return);
my ($id,$name,$lastname)= split('\n',$sql_return);
Can you please suggest if I'm missing anything here. Thanks!