Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

System.OutOfMemoryException thrown while passing CLOB from C#

ShashikanthJogiJul 12 2018 — edited Jul 12 2018

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.

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 9 2018
Added on Jul 12 2018
1 comment
1,052 views