= (1, 2, 3, 4, 5);
my $str = join (",", ("?") x @values);
Then interpolate $str into your query string.
>
> On 4/5/16 9:32 AM, Vaughan, Mark wrote:
>> >From the DBI documentation
>> >(https://urldefense.proofpoint.com/v2/url?u=https-3A__metacpan.org
From the DBI documentation
(https://metacpan.org/pod/DBI#Placeholders-and-Bind-Values):
Also, placeholders can only represent single scalar values. For example, the
following statement won't work as expected for more than one value:
"SELECT name, age FROM people WHERE name IN (?)"# wrong
"S
I'm trying to build DBI and DBD::Oracle to run on a Linux server
(2.6.18-274.7.1.el5) using the 11g (11.2.0.1) 32-bit client. The database
resides on a remote server and I can get to it just fine using sqlplus.
Here is the output from the make:
mvaughan - ni00 - /u/mvaughan/.cpan/build/DBD-Oracl