Re^2: DBD and bind_param (Oracle)

[Skeeve]

in reply to Re: DBD and bind_param (Oracle)
in thread DBD and bind_param (Oracle)

Not the answer I wanted to read but at least I don't need to search any further.

Thanks to both of you.

[herveus]

Howdy!

Now, there are other ways to work the problem that retain the use of bind variables. Consider:

my @values = qw/1 2 3/;
my $sql = 'select * from foo where x in (' . join(', ', ('?') x @in_va
+lues) . ')';
$dbh->prepare($sql)->execute(@values);

This preserves the use of placeholders and the benefits therefrom while adapting to the changing number of parameters. You can't avoid constructing the query to fit the data.