Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Conversion of BLOB into LONG RAW?
Yes, its possible. Trawl the archives for some of my postings on this. Also, have a look at mnetalink, as there are a few articles there
There are also a few lkimitations as well. Buyt in theory, it is possible.
Matt Houseman wrote in message <96kkjl$nd6$1_at_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 Tue Feb 20 2001 - 09:30:42 CST