Help!How to access the BLOB datatype of Oracle in CVI7.0

[vava]

Hello,

           I am using CVI7.0 and SQL2.0 tool kit in Microsoft 2000 platform.My problem is that i want to save a word (.doc) file as such in a database.For this in Oracle8i,9i and 10g there is a datatype called BLOB which  stores  the file in binary format.Now i am not sure whether CVI will support this datatype.Does DBMapColumnToBinary and DBBindColBinary satisfy my need?Can I retrieve the whole file from database in binary format using these commands?If possible how can I view the file back in its original format.If not,please propose solution for this problem.It's urgent .

                                                                Mala

[shahina]

Hello Mala,

You can use the DBGetColBinary function to get a binary data from a database column. There is an example provided in the manual here. Then you can use WriteFile function to write the binary data to a doc file. This discussion forum post performs the opposite action (writes a jpg file to a database), but it might be helpful as well.

Good luck and best regards,
Shakhina P.
Applications Engineer
National Instruments