in reply to Re: LOB's refetch improperly
in thread LOB's refetch improperly

Thanks for the quick reply.

SCHEMATABLE.TABLE does not exist, as the message says. I'm not sure where the message is generated from, as its internal to DBD::Oracle. This is, indeed, where the strangeness occurs.

I can insert things other than LOBs. I only have this problem with LOBs. Its trying to update the LOBs that I run into this strange issue. I've tried both BLOBs and CLOBs here, and found that with these two I get that error, but all other data types seem to work (anything non-lob, at least).

I have other programs (webapps) built using the same framework for web/db apps, and none of them have this issue. Some of them use the same codebase that generates this error.

The synonym is correct. Nobody, including a large team of DBAs, can fathom where this comes from.

I've used NONSCHEMA to connect to sqlplus and executed successfully a statement updating SCHEMA.TABLE.BLOBCOL with to_blob('1243').
Bro. Doug :wq

Replies are listed 'Best First'.
Re^3: LOB's refetch improperly
by bart (Canon) on Mar 19, 2007 at 20:28 UTC
    More and more, this begins to sound like a real DBD::Oracle/DBI bug to me, instead of just a user error. Perhaps you'd take this best to the DBI-Users mailing list, where the real DBI experts hang out, including the author of both DBI and DBD::Oracle: Tim Bunce.
      Excellent advice. I will. Thanks.
      Bro. Doug :wq