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').
| [reply] |
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.
| [reply] |
Excellent advice. I will. Thanks.
| [reply] |