System.OutOfMemoryException thrown while passing CLOB from C#

ShashikanthJogi

Hi All,

     Following exception is thrown while you pass a file as input type CLOB from .NET C# code. The file is of size around 40 MB. How to handle this case?

     Vesron of DLL used is  Oracle.DataAccess.dll - 4.121.2.0

System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.

at System.String.ToCharArray()

at Oracle.DataAccess.Client.OracleParameter.GetPreBindBuffer_Char(Int32 idx)

at Oracle.DataAccess.Client.OracleParameter.PreBind_Clob(OracleConnection conn, Boolean bIsFromEF, Boolean bIsSelectStmt)

at Oracle.DataAccess.Client.OracleParameter.PreBind(OracleConnection conn, IntPtr errCtx, Int32 arraySize, Boolean bIsFromEF, Boolean bIsSelectStmt)

at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)

at Oracle.DataAccess.Client.OracleCommand.ExecuteReader()

Best Regards.

Thiyagu - Oracle

Starting in 11g they have increased the size of a clob column to a Maximum size of (4 gigabytes - 1) * (database block size). However, when trying to insert more than 4 gigs it will throw error. But in you case it should  not.

Yon can try with InitialLOBFetchSize Property

http://www.oracle.com/partners/campaign/o65odpnet-085139.html

Also you  can share the code let me try in my end

Thanks

Thiyagu