OK, I did modify my Sequel connect call to include:
:after_connect => Proc.new { |conn| conn.long_read_len = 1073741824 }
(I couldn't get 2GB or 2GB - 1 to work, so I just went with 1GB for now.)
and that seems to have fixed my problem, but I guess my larger question is
still:
Can I access the instance methods of the Oracle adapter after Sequel
creates the connection?
Thanks!
Brian
On Friday, October 11, 2013 11:52:39 AM UTC-5, Brian wrote:
>
> I am investigating a problem I'm having using Sequel to retrieve data from
> an Oracle database. A particular column is of "LONG RAW" type. Using a
> "basic" Sequel connection, I get:
>
> stmt.c:267:in oci8lib_200.so: OCIError: ORA-01406: fetched column value
> was truncated (Sequel::DatabaseError)
>
> My research so far has determined:
>
> The OCI8 ruby adapter has a long_read_len=() method. By default, the
> long_read_len is set to 64KB, but a LONG RAW column can be up to 2GB. I
> assume this is done to minimize memory usage, but I'd prefer to bump it to
> 2GB to see if it fixes my problem (and I'll deal with memory issues at that
> point).
>
> I can't figure out how to call the long_read_len=() method on the Oracle
> connection after it's established by Sequel.
>
> Can anyone help me?
>
> Thanks!
> Brian
>
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/groups/opt_out.
