Slash Boxes  All the Perl that's Practical to Extract and Report
use Perl Log In  Log In  [ Create a new account ]  jdavidb
(1361)    (email not shown publicly)   Journal of jdavidb (1361)
Tuesday November 18, 2003 01:53 PM   [ #15846 ]  Got a situation
where I prepare a DBI SQL statement handle, but when I execute
it it fails saying I have a non-numeric value where it doesn't
belong. However, when I substitute the variables directly into
the statement and punch it into SQL plus, it works. Is there a
way to tell the statement handle to print out what SQL text it
thinks it's executing, complete with bound parameters?  Update:
I figured out what I was doing wrong. I have a Time::Piece and I
want to insert it into a date column in a table.  my $date =
Time::Piece->new; my $sql = qq{  However, I knew that wouldn't
work directly (and I figured if it did I might get bit by
conversions), so I wrote a little datequote routine that returns
a string TO_DATE('2003-11-18 13:15:23', 'YYYY-MM-DD
HH24:MI:SS'). Then I just