From: KUBO Takehiro <kubo@...>
Date: 2003-05-04T02:31:01+09:00
Subject: Re: DBI/OCI8 & binary data

Ollivier Robert <roberto@REMOVETHIS.eu.org> writes:

> In article <19BFXp-2c5-00@mail.jiubao.org>,
> KUBO Takehiro  <kubo@jiubao.org> wrote:
>> Could your another program read a BLOB?
>
> Well, I can see data in the table with a SQL browser (TORA but Toad under
> Windows see it too).
>
>> ruby-oci8 raises 'uninitialized BLOB' when OCI8::BLOB#available? is
>> false. OCI8::BLOB#available? is OCILobLocatorIsInit() in C. I don't
>> know the portable ways to check whether the BLOB column is initialized
>> or not. I would read the document of LOB at the next weekend.

Sorry I forgot to return nil when fetched data is null.
I think error data which raises 'uninitialized BLOB' is null.
Please try following tar-ball:
   http://www.jiubao.org/ruby-oci8/ruby-oci8-0.1.3-test1.tar.gz

If my assumption is correct, it will raise "undefined method `read'
for nil (NameError)" instead of "uninitialized BLOB". If so, please
check whether that data is null or not by following SQL. 

  SELECT id_activity FROM acb_logo WHERE object is null;

If not so, please send dump file to me.

  $ exp userid=<USERID>/<PASSWORD> tables=acb_logo file=acb_logo.dmp
  $ bzip2 -9 acb_logo.dmp

Please compress as small as possible. The band-wide between the
Internet and my home is extremely narrow.

-- 
KUBO Takehiro