Hi, The solution described above help me to solve the problem where I needed to fire sqlplus query from perl script. I was using .sql file method earlier as below and was searching where I can pass the query straight to Perl. $account = `sqlplus -s CPS_RW_USR/cps_rw_usr\@CPS_T3A.O2 \@test.sql`; However the problem now I am facing is with the above solution that I cant put any variables in the query as it gives error. For eg. I want to fire below query on emp table where id=10. So I did something like: my $id=10; __DATA__ select * from emp where id='$id'; exit; However it says no row selected. The problem is that value of variable is not getting detected in this script. Can you guys please help. Please reply me on veki.ldh@gmail.com Thanks Vivek Malhotra