[ANN] ruby-oci8 1.0.0-rc2

K

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Staff online

Members online

Forum statistics

Threads
474,056
Messages
2,570,441
Members
47,118
Latest member
nocode69

Latest Threads

Top