RE: bind variable problem



John Scoles [mailto:scoles@xxxxxxxxxxx] wrote:

Your first pattern is correct. In the second one you cannot use bind in an
in statment like this as it connot correctly quote the params. Not sure if
this is an DBI thing or DBD::Orale OCI thing though

I can't figure out what you mean by this. In the first block of code, the
number of placeholders is determined based on the size of @ltables; in the
second block of code, the number of placeholders is hard-coded at 5. Other than
that, the two SQL statements are *exactly the same*.

Ronald

.