in reply to question mark?
As Trimbach pointed out, creating a subroutine to handle
miscellaneous SQL is not always a good idea unless you
know what you're doing with it.
That said, your real problem is that you're using " and not '. In my testing, I have found that text inside 's is immune to being replaced by bind variables. I could be wrong, though. :-)
INSERT INTO some_tbl (some_text) VALUES('Hello?') works in Oracle, at least, using your subroutine.
That said, your real problem is that you're using " and not '. In my testing, I have found that text inside 's is immune to being replaced by bind variables. I could be wrong, though. :-)
INSERT INTO some_tbl (some_text) VALUES('Hello?') works in Oracle, at least, using your subroutine.
In Section
Seekers of Perl Wisdom