How to Insert data from Blob field to Oracle Database
-
Hi; I m using VB.net. I have inserted the data in SQLSERVER in this form but having this error while trying in Oracle. Im using class for connection "ORA-01036, Illegal Name/Variable " this is the Code I m using. Dim LclsGeneral As New GClsGeneral Dim fs As FileStream = New FileStream(txtContent.Text, FileMode.Open, FileAccess.Read) Dim img(fs.Length) As Byte fs.Read(img, 0, System.Convert.ToInt32(fs.Length)) Dim conn As New OracleClient.OracleConnection Dim LClscnn As New GClsConnection conn.ConnectionString = LClscnn.GetConnectionString If conn.State = ConnectionState.Closed Then conn.Open() Dim Lcmd As New OracleClient.OracleCommand Lcmd.Connection = conn Lcmd.CommandText = "Insert into Test (DOCUMENTID,DOCUMENTCONTENT) VALUES ('" & txtID.Text & "',@DOCUMENTCONTENT)" Lcmd.Parameters.Add("@DOCUMENTCONTENT", OracleClient.OracleType.Blob,img.Length).Value = img Lcmd.ExecuteNonQuery() fs.Close() txtID.Text = "" txtContent.Text = "" Kindly help me Thank you