Home » Infrastructure » Windows » Problem with BLOB using OraOLEDB.Oracle 8.1.7.3
Problem with BLOB using OraOLEDB.Oracle 8.1.7.3 [message #100345] Mon, 28 October 2002 20:25 Go to next message
Zunil P John
Messages: 2
Registered: October 2002
Junior Member
Hi ,

I have an application written in C++ which uses OraOLEDB provider…Earlier
I used OraOLEDB.Oracle 8.1.6 and it works fine…

But now I upgraded to OraOLEDB.Oracle 8.1.7.3…. and the problem
starts…Now I am not able to view data in fields of type BLOB/LONG….BOB
fields returns value NULL….but Value is there in the field…I am able to
insert data to blob field using my application..

My question is : Is there any special seting for OraOLEDB.Oracle 8.1.7 to
retrieve data from a BLOB field other than settings for OraOLEDB 8.1.6

If anyone knows any solution, please post it...
Thanks,

Regards

Zunil P John
Re: Problem with BLOB using OraOLEDB.Oracle 8.1.7.3 [message #100352 is a reply to message #100345] Wed, 06 November 2002 21:19 Go to previous message
Zunil P John
Messages: 2
Registered: October 2002
Junior Member
Hi all,

I got the problem..In my code for blob foields I set dbbinding.cbMaxLen = 0 ...But from 8.1.7.x onwards we have to provide a non-zeo value to cbmaxlen.

So I put dbbinding.cbMaxLen = sizeof(IUnknown *)..

It works perfectly fine...

Thanks

Regards

Zunil P John
Previous Topic: VB6 Oracle Connection without installing Oracle Client...
Next Topic: ORA-12560 protocol adapting error
Goto Forum:
  


Current Time: Thu Mar 28 12:58:26 CDT 2024