Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> help, i can't insert a blob

help, i can't insert a blob

From: juan <aaaaa_at_aaa.com>
Date: Sat, 08 May 2004 21:31:19 +0200
Message-ID: <39dq90p22rnqmn74svbsjpf876iieaob98@4ax.com>


i have this code, but the error i obtain is: OIP-04903: Row must be locked for this LOB operation

Dim OraDb As OraDatabase
Dim Sesion As OraSession

Dim OraDyn As OraDynaset
Dim OraSound As OraBlob

Private Sub Command2_Click()
On Error GoTo errorinsertar
Set Sesion = CreateObject("OracleInProcServer.XOraSession") Set OraDb = Sesion.OpenDatabase("JUAN", "garay/10061981", 0&)

Set OraDyn = OraDb.CreateDynaset("select * from GARAY.PRUEBA", ORADYN_DEFAULT)
Set OraSound = OraDyn.Fields("FOTO").Value

'OraDyn.Edit

OraDyn.AddNew
OraSound.CopyFromFile "c:\uno.jpg"
OraDyn.Update
MsgBox "Insercion correcta"
Exit Sub

errorinsertar:
'MsgBox "Error al inertar la foto"

MsgBox Error
End Sub Received on Sat May 08 2004 - 14:31:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US