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.
···
-----Original Message-----
From: pauljbarry3@gmail.com [mailto:pauljbarry3@gmail.com] On
Behalf Of Paul Barry
Sent: Tuesday, May 30, 2006 3:08 PM
To: ruby-talk ML
Subject: Re: Passing an array to DBI statement execute
Ok, well, now it executes and seems like it is working,
except nothing ends up in my database. Any ideas? Is there
any way to print out what sql statement it is trying to
execute? I can't find any API docs for DBI.
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.
···
On 5/30/06, Berger, Daniel <Daniel.Berger@qwest.com> wrote:
> -----Original Message-----
> From: pauljbarry3@gmail.com [mailto:pauljbarry3@gmail.com] On
> Behalf Of Paul Barry
> Sent: Tuesday, May 30, 2006 3:08 PM
> To: ruby-talk ML
> Subject: Re: Passing an array to DBI statement execute
>
> Ok, well, now it executes and seems like it is working,
> except nothing ends up in my database. Any ideas? Is there
> 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.