Perl DBI Oracle: bind an array list

2007-02-16 Thread Nitin Aggarwal
Hi, I am using bind variables for executing a select query which uses in operator. Following is the prototype of my code: $query = select a from tab where b in (:1); @list = {A,B,C,D}; $list_values = join(',',@list); $DBI- connect (..); $sth - prepare($query); $sth- execute ($list_values);

Re: Perl DBI Oracle: bind an array list

2007-02-16 Thread Igor Sutton
Hi Nitin, 2007/2/16, Nitin Aggarwal [EMAIL PROTECTED]: Hi, I am using bind variables for executing a select query which uses in operator. Following is the prototype of my code: $query = select a from tab where b in (:1); @list = {A,B,C,D}; $list_values = join(',',@list); $DBI- connect (..);