insert image in to oracle blob data type

rajesh_bamane · April 19th, 2006, 06:02 AM

i have problem in inserting image in oracle database using blob data type
plz help me

Raj

khronikles · May 11th, 2006, 11:23 AM

Try
http://forums.oracle.com/forums/forum.jspa?forumID=61

and post your problems there. Response time is quick

shah_shah · July 6th, 2006, 03:46 AM

dear Raj,
have you get solution about this problem if yes then tell me how can insert image in blob data type.

Quote:

quote:Originally posted by rajesh_bamane
i have problem in inserting image in oracle database using blob data type
plz help me

Raj

JGumia · July 15th, 2006, 02:06 AM

Private Sub CopyBlob(fname As String)
On Error GoTo ErrorSub

    Dim OraBlob As OraBlob
    Dim Part As OraDynaset
    Dim PartImage As OraBlob

    Set Part = g_OraDatabase.CreateDynaset("select * from blob_test where id = 4", 10&)

    Set PartImage = Part.Fields("Blob_Object").Value

    PartImage.CopyToFile fname, 10000, 1000

    Exit Sub

ErrorSub:

End Sub

"What on Earth am I here for"