Click here to Skip to main content
15,885,278 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
See more:
Hi everyone,

i am new to Asp.net and oracle,

Here i want to fetch the email(BLOB Type) from the table , problem is while i fetch the blob data through datatable, the xml data contains SYSTEM.Byte[]
here sample code
-----------------
Dim Dt As New DataTable
VB
If Dt .Rows.Count > 0 Then
                If (Not Dt .Rows(0).Item(0) Is DBNull.Value) Then

                    blobMail = DirectCast(Dt .Rows(0).Item(0), Byte())
                    
                End If
            End If


here actually datatable object Dt should contain BLOB values like 0101 2001, but its fetch this SYSTEM.Byte[]

i dont know how to solve this.
So Could you help me anyone
Thanks in advance

Velsamy
Posted

1 solution

Please read this article.You can find everything about the oracle blob data type.Good Luck ! :)

How to read a BLOB
 
Share this answer
 
v2
Comments
avelsamy 21-Apr-14 9:12am    
thank you... i will be in touch
Sampath Lokuge 21-Apr-14 9:17am    
Yep,Great. :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900