Conversion of BLOB into LONG RAW?

From: Matt Houseman <mhousema_at_ix.netcom.com>
Date: Fri, 16 Feb 2001 17:49:23 -0800
Message-ID: <96kkjl$nd6$1@slb0.atl.mindspring.net>

All,

I'm working with a client who insists on using ADO and the Microsoft ADO Provider. BLOB's must be stored as these BLOB's must be replicated to another database and LONG RAW's can't be replicated.

The problem is this: the binary image must be returned from a stored procedure to an application written in VB using the Microsoft ADO Provider. Whenever a BLOB is returned, the application simply hangs. When the column was a LONG RAW, the application worked like a champ.

Questions:
1) Is it possible to convert a BLOB to a LONG RAW and if so, how? 2) Is there a size limitation on OUT parameters for VARCHAR2 in a stored procedure as the thought occurs that I could use the DBMS_LOB.READ package and method. The client's binary traces approach 16K in size.

Thanks to all,
Matt Houseman Received on Fri Feb 16 2001 - 19:49:23 CST