By enabling DBI's tracing capabilities, extensive info is logged about the communication between your script and the database. You will see the statements received by the database server after any variable interpolations or placeholder substitutions.

DBI offers 5 levels of tracing, from 1 to 5. Use 0 to disable tracing; 2 gives you a good result for debuging. You use it by setting the environment variable DBI_TRACE or by using the method trace on either your hanlde or as a class method.

See DBI 's documentation for a thorough discussion.

I hope this helps,

Julio