有关ORACLE的读和写BLOB的问题
请问那位高手能帮帮我:我要在一个oracle数据库表中存储一个大文件,用的语句是: objOraCommd.CommandText = "BEGIN select " & pstrBlobFieldName & " into :objOraBlobPicture from " & pstrTableName & " where UPPER(" & pstrControlField & ") =" & "'" & pstrControlFieldValue.ToUpper & "'" & " for update NOWAIT; END;"
Dim fsSourceFile As FileStream = New FileStream(pstrFileName, FileMode.Open )
fsSourceFile.Read(bytbuffer, 0, fsSourceFile.Length)
然而,当执行到: objOraBlobPicture.Write(bytbuffer, 0, bytbuffer.Length)
时,有时就会出现这样的错误:“Error Code:0 Internal error not handle(-2)“
,可有时是好的,问什么?
谢谢大家,帮我想想办法!