|Syntactic Confectionery Delight|
Strange errors with DBD::Oracle and placeholdersby Skeeve (Vicar)
|on Mar 28, 2012 at 11:58 UTC||Need Help??|
Skeeve has asked for the
wisdom of the Perl Monks concerning the following question:
I'm encountering strange errors when using placeholders in an sql query, using an Oracle database. For example this query gives me
This is the code I use:
When I replace ":TIMEZONE" with the string "'Europe/Berlin'", it works, so it is not an issue of the query itself.
In the real production code I use, the error is even more strange, as it tells me something about illegal relational operators.
Is this behaviour somewhere documented in DBD::Oracle? I couldn't find it.
Thanks for your help.