I'm trying to insert a date object in an Oracle database, and I'm
getting the following error. What am I doing wrong, (I'm really trying
to insert date of the format: 23-sep-2009 10:42:36)
Ruby 1.8.7, Sequel 1.3.4, oci8 1.0.6 (reproduced with 2.0.2) Oracle XE
10.2.0
Thanks.
Error:
stmt.c:539:in oci8lib.so: ORA-01874: time zone hour must be between
-12 and 14 (OCIError)
from /var/lib/gems/1.8/gems/ruby-oci8-1.0.6/lib/oci8.rb:759:in
`exec'
from /var/lib/gems/1.8/gems/ruby-oci8-1.0.6/lib/oci8.rb:142:in
`do_ocicall'
from /var/lib/gems/1.8/gems/ruby-oci8-1.0.6/lib/oci8.rb:759:in
`exec'
from /var/lib/gems/1.8/gems/ruby-oci8-1.0.6/lib/oci8.rb:255:in
`exec'
from /var/lib/gems/1.8/gems/sequel-3.4.0/lib/sequel/adapters/
oracle.rb:66:in `execute'
from /var/lib/gems/1.8/gems/sequel-3.4.0/lib/sequel/
connection_pool.rb:112:in `hold'
from /var/lib/gems/1.8/gems/sequel-3.4.0/lib/sequel/
database.rb:481:in `synchronize'
from /var/lib/gems/1.8/gems/sequel-3.4.0/lib/sequel/adapters/
oracle.rb:64:in `execute'
from /var/lib/gems/1.8/gems/sequel-3.4.0/lib/sequel/
database.rb:312:in `execute_dui'
from /var/lib/gems/1.8/gems/sequel-3.4.0/lib/sequel/
database.rb:319:in `execute_insert'
from /var/lib/gems/1.8/gems/sequel-3.4.0/lib/sequel/dataset.rb:
349:in `execute_insert'
from /var/lib/gems/1.8/gems/sequel-3.4.0/lib/sequel/dataset.rb:
204:in `insert'
from db_test_new.rb:14:in `test_insert'
from db_test_new.rb:22
[1] 4815 exit 1 ruby db_test_new.rb
I've replicated the same with OCI8 version 2.02.
Code sample:
require 'rubygems'
require 'sequel'
$DB = Sequel.connect(:adapter => 'oracle', :database => 'XE', :user =>
'myuser', :password=> 'mypassword')
def create_t_test
$DB << 'create table t_test (
F_ID number,
F_DATE date
)'
end
def test_insert
$DB[:t_test].insert(
:F_ID => 1,
:F_DATE => Time.now
)
end
# $DB << 'drop table t_test'
create_t_test
test_insert
puts $DB['select * from t_test'].first
$DB << 'drop table t_test'
exit
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
