http://www.perlmonks.org?node_id=876279


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

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.

yours,
Michael