Oracle 8.1.5 blob handling in XA environment

We have an application that uses oracle as a database server
and tuxedo as a transaction manager in XA environment.
This application was working with Oracle 8.0.5 but not
with 8.1.5 and I have traced the problem to the following
SELECT FOR UPDATE statement which is supposed to lock the row and get the blob handles.

   exec sql
   select certificate, revokedata
   into :certificate, :revokedata
   from pubdb
   where
   regionid = :pubdb.regionid
   AND nodeid = :pubdb.nodeid
   AND serverid = :pubdb.serverid
   AND certserial = :pubdb.certserial
   for update
   ;
certificate and revokedata are blob type in pubdb table.

The error is ORA-24813
24813, 00000, "cannot send or receive an unsupported LOB"
// *Cause: An attempt was made to send a LOB across the network, but either
// the server does not support the LOB
sent by the client, or the
// client does not support the LOB sent
by the server. This error
// usually occurs when the client and
server are running different
// versions of Oracle.

// *Action: Use a version of the Oracle that supports the LOB on both
// the client and the server.

As I said this works with Oracle 8.0.5 so I just removed this query and the
rest of the program works but blobs are not inserted.
I also tried sample4.pc program in our compile environment and it
works too so SELECT FOR UPDATE works in our build/run environment.

Any help with this problem is greatly appreciated.

Thanks

Amir Behroozi

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 22 1999 - 20:56:59 CST