[ANN] ruby-oci8 1.0.0-rc2

[KUBO Takehiro]

ruby-oci8 1.0.0-rc2 is released. This is a Oracle module using OCI8 API.

http://rubyforge.org/projects/ruby-oci8/

What's new.

1. support SQL*Plus-like connect strings.
(contributed by Oracle Corporation)

require 'oci8'
conn = OCI8.new('username/password@tns_name')
# instead of OCI8.new('username', 'password', 'tns_name')

2. Add a rpm spec file.
(contributed by Brian Candler)

rpmbuild -tb ruby-oci8-x.y.z.tar.gz

/usr/src/redhat/RPMS/i386/ruby-oci8-x.y.z-1.i386.rpm

3. support BINARY_FLOAT and BINADY_DOUBLE columns.
(This problem is reported by Duncan McCaffery.)

4. support NCLOB columns.
(This problem is reported by Dmitry Zadvornykh.)

cursor = conn.exec('select nclob_column from nclob_table')
cursor.fetch # => [ instance of OCI8::NCLOB ]

5. add new CLOB/NCLOB/BLOB insert method.
(This is available on Oracle 8.1.5 or later.)

cursor = conn.parse("INSERT INTO clob_table VALUES 1)")
cursor.bind_param(1, OCI8::CLOB.new(conn, lob_data))
cursor.exec

cursor = conn.parse("INSERT INTO nclob_table VALUES 1)")
cursor.exec(OCI8::NCLOB.new(conn, lob_data))

conn.exec("INSERT INTO blob_table VALUES 1)",
OCI8::BLOB.new(conn, lob_data))

This is added to insert CLOB as a SDO_GEOMETRY's parameter
to solve a problem reported by Pete Schwamb.

6. add an error location in C code to OCIException's backtrace.
This is for debug information.

 

[KUBO Takehiro]

Hi,

ruby-oci8 1.0.0-rc2 is released. This is a Oracle module using OCI8 API.

http://rubyforge.org/projects/ruby-oci8/

I replaced the tar-ball at rubyforge.
The old one had a bug when compiling with gcc-4.1.
I have not noticed it because gcc-3.3 doesn't complain about it.

Thanks to Eric Snyder.