Viewing SQL after parameters are bound to PreparedStatement

From: <bsnyder_at_NO-SPAM-pclnxbsnyder.digitalglobe.com>
Date: Wed, 30 Apr 2003 18:11:05 +0000
Message-ID: <pan.2003.04.30.18.11.05.836261.29355@NO-SPAM-pclnxbsnyder.digitalglobe.com>

I'm having trouble with some DML that is deleting from a table using two oracle.sql.TIMESTAMPs. If I run the SQL by hand via SQL*Plus the correct rows are removed from the table. If the SQL is executed via an oracle.jdbc.driver.OraclePreparedStatement nothing is deleted. One of my guesses is that something may be wrong with those TIMESTAMPs as they're bound to the OraclePreparedStatement. However, I cannot determine if this is the case without viewing the SQL *after* those parameters have been bound.

Does anyone know any tricks to viewing SQL from an OraclePreparedStatement after parameters have been bound to it?

Thanks! Received on Wed Apr 30 2003 - 13:11:05 CDT