# Re: Passing an array to DBI statement execute

**URL:** <https://www.ruby-forum.com/t/re-passing-an-array-to-dbi-statement-execute/95386>\
**Category:** Ruby\
**Created:** [May 30, 2006, 11:12pm UTC](https://www.ruby-forum.com/t/re-passing-an-array-to-dbi-statement-execute/95386 "2006-05-30T23:12:24Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![BergerS\_Daniel](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/bc8723/32.png) [@BergerS\_Daniel](https://www.ruby-forum.com/u/BergerS_Daniel)\
**Post date:** [May 30, 2006, 11:12pm UTC](https://www.ruby-forum.com/t/re-passing-an-array-to-dbi-statement-execute/95386/1 "2006-05-30T23:12:24Z")

</div>

> any way to print out what sql statement it is trying to  
> execute? I can’t find any API docs for DBI.

Are you doing dbh.commit before you’re finished? I believe autocommit  
defaults to false with OCI8.

Regards,

Dan

This communication is the property of Qwest and may contain confidential  
or  
privileged information. Unauthorized use of this communication is  
strictly  
prohibited and may be unlawful. If you have received this communication  
in error, please immediately notify the sender by reply e-mail and  
destroy  
all copies of the communication and any attachments.

---

<div class="post-metadata">

**Author:** ![BergerS\_Daniel](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/bc8723/32.png) [@BergerS\_Daniel](https://www.ruby-forum.com/u/BergerS_Daniel)\
**Post date:** [May 30, 2006, 11:27pm UTC](https://www.ruby-forum.com/t/re-passing-an-array-to-dbi-statement-execute/95386/2 "2006-05-30T23:27:48Z")

</div>

thanks, needed to explictly commit. And for the record, DBI  
automatically  
handles the Time objects, they end up as valid DATE values in the  
database.