Member Avatar for raviseelam

Hi All,

I created a table with blob datatype in oracle and store the .doc and pdf file in that column
But when i try to access the data from that table i am faceing an error data is corrupted.

i am using php 5.2 and adodb driver and oracle 10i .

Please help meee

Thanks

  • 3 Contributors
  • 4 Replies
  • 117 Views
  • 11 Months Discussion Span
  • Latest Post Latest Post by hemadri123
Member Avatar for debasisdas

how you hae stored the files in dtabase. Is it is in binary format .

Member Avatar for raviseelam

I used php to store the .doc file in to oracle database. yep i stored the binary data of the file in the blob column.....

Member Avatar for debasisdas

when you try to retrive you will get binary data, you have to conert the same to file to get your actual data.

Member Avatar for hemadri123

I have an similar problem in MS access.
I have imported the table then created a form using form wizard.
but for the BLOB it shows empty

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.