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.
on 2006-01-17 22:08
on 2006-01-18 04:49
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...