Thank you very much for the reply. I got the following error after I
applied the patch:
Not supported type (8)
I changed bind_param to
c.bind_param(’:data’, data, OCI8::SQLT_LNG)
If I do not change it, I end up with truncated data.
As for changing “datasize = 65535”, I did “datasize = 500000”. However,
when querying the database populated by other means with 200k long
columns, I always get back a string of size 65535. This limitation must
be in place somewhere else (inside OCI?).
Thanks again for trying to help. I ended up using OTL (C++) for
populating and updating long columns, as pure OCI interface simply
overwelms me. It would be great, though, to have support for this in
Ruby OCI8 later sometime.