RE: suppress quoting in prepared sql

2016-04-05 Thread Vaughan, Mark
ter # per element in an array of values. my @values = (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 >> >(http

RE: suppress quoting in prepared sql

2016-04-05 Thread Vaughan, Mark
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

Build error - DBD::Oracle, Oracle 11.2.0.1, 32-bit client, remote DB

2014-01-16 Thread Vaughan, Mark
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 -