Re: Problem with selecting rows from a database link

2007-09-24 Thread Tony Green
On Monday 17 Sep 2007, Crosbourne, Rainaldo wrote: Hey guys I am trying to query a table using a database link, using the following code: use strict; use DBI; my $col_value = 'test'; my $query = 'select col_1,col_2,col_3 from [EMAIL PROTECTED] where col_1 = ?'; my $dbh =

Problem with selecting rows from a database link

2007-09-17 Thread Crosbourne, Rainaldo
Hey guys I am trying to query a table using a database link, using the following code: use strict; use DBI; my $col_value = 'test'; my $query = 'select col_1,col_2,col_3 from [EMAIL PROTECTED] where col_1 = ?'; my $dbh = DBI -connect ('dbi:Oracle:dbs','username','password',{