Forum: Ruby Re: Populating 'long' data column with Ruby OCI8 (trying aga

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
397f61cc4458e13157b4facf72325e5f?d=identicon&s=25 Gennady Bystritsky (Guest)
on 2006-01-17 22:08
(Received via mailing list)
Thank you very much, Neil. I saw blob support in OCI8, however I need to
work with datatype 'long'. I need to for dealing with a legacy database
that cannot be altered in any way. Will OCI8 work on 'long' columns? I
will definitelly try, however I doubt it.

Thanks a lot anyways,
Gennady.
59c57451c9fe66b55b0f163806b659ba?d=identicon&s=25 Neil Kohl (Guest)
on 2006-01-18 04:49
(Received via mailing list)
Sorry, saw "long", thought "lob".

The problem is that there's a default buffer size for working with
longs/lobs that you have to reset to a value that's appropriate for your
data.

In perl DBI there's a LongReadLength attribute, and it looks like
there's
something similar for oci8 via the "low level" interface (maybe
OCI_ATTR_MAXDATA_SIZE). But there doesn't appear to be a way to set OCI
attributes from the "high level" interface, unless I'm missing
something.
Which is likely...
This topic is locked and can not be replied to.