How to Store Word Document in Oracle 10G - How to use CLOB/BLOB in Oracle 10G in asp.net,vb.net,C#.net?

I need to store physical Word document in oracle column which defined with one of data type CLOB/BLOB using ASP.Net and C#.

Your help defiantly help me lot

REPLY :1

This would help to upload a document to BLOB data type field in oracle.

Use .Net framework 2.0 and Oracle DB.

Code start from here

            Dim strFilename As String = FileUpLoad1.FileName

            If FileUpLoad1.HasFile Then

                FileUpLoad1.SaveAs(strFullPath)

  lblupload.Text = "File Uploaded: " & FileUpLoad1.FileName & " Content Type " &   FileUpLoad1.PostedFile.ContentType & " Length " & FileUpLoad1.PostedFile.ContentLength

                strUploadMode = "Uploaded"

                strUploadType = FileUpLoad1.PostedFile.ContentType

                                   strUploadExt=Getfileextension(strFullPath)

    ‘Getting connectionstring

            Dim strconnString As String = ConfigurationManager.AppSettings("Connstring")

            Using connOra As New OracleClient.OracleConnection(strconnString)

                Dim blobparameter As New OracleClient.OracleParameter()

                blobparameter.OracleType = Data.OracleClient.OracleType.Blob

                blobparameter.ParameterName = "BlobParameter"           

                    Dim iResult As Int32

                    Dim buf As Byte()

                    Dim fStream As System.IO.FileStream

                    Dim iLength As Integer

                    Dim sFile As String = strFilename

                    Dim sFileAndPath As String = strFullPath

                    fStream = New System.IO.FileStream(strFullPath, FileMode.Open, FileAccess.Read)

                    iLength = fStream.Length - 1

                    fStream.Position = 0

                    buf = New Byte(iLength) {}

                    fStream.Read(buf, 0, iLength)

                    fStream.Close()               

                    blobparameter.Value = buf

                    Dim strUpdateStmt As String = "UPDATE <tablename> SET <column1> = " & " :BlobParameter  " & ", <Column2> = '" & strUploadExt & '

                    Dim cmdOra As New OracleClient.OracleCommand(strUpdateStmt, connOra)

                    cmdOra.Parameters.Add(blobparameter)

                    cmdOra.CommandType = CommandType.Text

                    Try                  

                        connOra.Open()

                        cmdOra.ExecuteNonQuery()                 

                    Catch ex As Exception                

                        Response.Write("Error”)

                    End Try

  

I hope this sample code would help.

-Shafeek.

Note : Provide your comments by clicking beloe options! Thanks ! :)

Tweet