p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Pro VB Databases (http://p2p.wrox.com/forumdisplay.php?f=81)
-   -   insert image in to oracle blob data type (http://p2p.wrox.com/showthread.php?t=41459)

rajesh_bamane April 19th, 2006 06:02 AM

insert image in to oracle blob data type
 
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"


All times are GMT -4. The time now is 01:58 AM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.