Ideally the actions insert/update/delete should be followed by a
`commit' command on oracle db to permanently apply changes. As far as
i know ruby-oci8 driver by default has autocommit boolean property as
false.
There is some way to enable autocommit from my ruby code (via sequel),
without altering the defaults of ruby-oci8?
And one more question. There is some way to execute a series of
semicolon-separated raw sql statements ? for example
DB = Sequel.connect('oracle://schema1:[email protected]:1521/MYDB')
DB['select * from admin_sec_user_account where user_id = 5; 'update
admin_sec_user_account set email_address = '[email protected]' where
user_id = 2']
Executing the second sql statement will complain about the
intermediate semicolon divisor.
Thank you in advance.
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sequel-talk?hl=en.
