Re^2: Question on inline redirection

Kyle,

You are my Monk of the year!

Your explanation not only fixed my issue. It also gave me a quick lesson on Quoting. I honestly did not think that single and double quotes acted the same way in Perl as they do in Unix shell scripts.

Thank you so much.

Regards.

Ash

Comment on Re^2: Question on inline redirection

Replies are listed 'Best First'.
Re^3: Question on inline redirection by Anonymous Monk on Apr 28, 2012 at 22:14 UTC
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	[reply]

Replies are listed 'Best First'.

Re^3: Question on inline redirection
by Anonymous Monk on Apr 28, 2012 at 22:14 UTC

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

[reply]