not able to insert timestamp objects

[schaary]

Hi,

I use an 'Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production'. Ruby v2.0.0 - v2.1.4 and ruby-plsql v0.5.2.

I try to insert a timestamp in a table but nothing happens. Like this:

create table tmp_time_tbl (
  time_stamp timestamp;
);

and then in ruby

require 'ruby-plsql'

# connect to oracle db

ts = { time_stamp: Time.now }

tmp_time_tbl.insert ts

It returns nil and nothing is inserted. When I insert a value by sqlplus, then I can fetch it:

pry [v2.1.4]  >> ap plsql.tmp_time_tbl.first 
{
    :time_stamp => 2014-11-09 08:36:40 +0100
}
=> nil

ap is awesome_print.

The problem still exists, when I try it by using pl/sql functions. If you are interested, I can post a example too.

[rsim]

The one thing I noticed is that you need to use plsql.tmp_time_tbl.insert ts and not tmp_time_tbl.insert ts

If you already did that and this was a spelling mistake then please debug https://github.com/rsim/ruby-plsql/blob/master/lib/plsql/table.rb#L168-L180 and see what is happening there and if correct INSERT statement is executed.

[schaary]

Sorry - it was a mistake in writing. I didn't copy&paste but wrote the command lines by hand. Here is the original:

2.1.4 >> ts = { time_stamp: Time.now }
=> {
    :time_stamp => 2014-11-09 08:34:45 +0100
}
2.1.4 >> plsql.tmp_time_tbl.insert ts
=> nil
2.1.4 >> ap plsql.tmp_time_tbl.first
{
    :time_stamp => 2014-11-09 08:36:40 +0100
}
=> nil
2.1.4 >> plsql.tmp_time_tbl.insert ts
=> nil
2.1.4 >> ap plsql.tmp_time_tbl.first
{
    :time_stamp => 2014-11-09 08:36:40 +0100
}
=> nil
2.1.4 >> ap plsql.tmp_time_tbl.all
[
    [0] {
        :time_stamp => 2014-11-09 08:36:40 +0100
    }
]
=> nil
2.1.4 >> exit

I inserted one data set in between by sqlplus to see, whether the database works at all. I will try to debug the the lines you've noticed.

[jgebal]

is this still open?

[javornikolov]

For me same example works OK. @schaary, are you still able to reproduce the issue?

[jgebal]

no response/ if it works for you I guess we can close this for now