Ruby-oci8 1.0.0-rc2

Ruby
1

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 C.)

    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.

2

Hi,

On 4/23/07, KUBO Takehiro [email protected] wrote:

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.