| Message: 95584 |
 |
BY: Kubo Takehiro (kubo)
DATE: 2010-12-21 13:44
SUBJECT: RE: Exception with DATE columns in Oracle 11g > I can't easily change that C file and re-compile unfortunately, as I don't have control over the server.
Could you use gcc on the server?
If so, you can compile ruby-oci8 and use it without installation as follows:
tar xvfz ruby-oci8-2.0.4.tar.gz
cd ruby-oci8-2.0.4
make
irb -Iext/oci8 -Ilib -roci8
The key point is "-Iext/oci8 and -Ilib."
Could you try the patch in the following URL?
https://gist.github.com/749935
cd ruby-oci8-2.0.4
patch -p0 < timeoffset_patch.dif
make
Then check the following SQL statements before and after "alter session set time_zone = ..." in irb.
conn.select_one("select to_timestamp_tz('2010-01-02 03:04:05 06:07', 'YYYY-MM-DD HH24:MI:SS TZH:TZM') from dual")
conn.select_one("select to_timestamp('2010-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS') from dual")
conn.select_one("select to_date('2010-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS') from dual")
| |
Start New Thread
Exception with DATE columns in Oracle 11g