From: Gennady Bystritsky <Gennady.Bystritsky@...>
Date: 2006-01-17T14:29:23+09:00
Subject: Populating long data column with Ruby OCI8

------_=_NextPart_001_01C61B26.F1CAF389
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi, friends

I am back to the list after a while. And I start the reunion with a =
question ;-).

Is there any way to insert a big chunk of data (say, 100K) into a column =
of type long with Ruby OCI8 or by any other Ruby means? I saw that to do =
it in C you must be prepared to handle OCI error code inviting you to =
insert another piece. But how to do it in Ruby, especially with OCI8? If =
I do=20

require 'oci8'

db =3D OCI8.new 'system', 'manager'
db.exec("create table sample (id number, data long)")

data =3D 'A' * 1024 * 100

c =3D db.parse('insert into sample values (2, :data)')
c.bind_param(':data', data)

c.exec
db.commit

What I end up with in column 'data' is host dependent (or db block size =
dependent?). I observed 14464 bytes on 2K database on Solaris, and 34652 =
bytes on 8K database on Linux.

Thank you,=20
Gennady Bystritsky.



------_=_NextPart_001_01C61B26.F1CAF389--