System.OutOfMemoryException thrown while passing CLOB from C# — oracle-tech

    Forum Stats

  • 3,716,000 Users
  • 2,242,928 Discussions
  • 7,845,734 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

System.OutOfMemoryException thrown while passing CLOB from C#

ShashikanthJogi
ShashikanthJogi Member Posts: 1
edited July 2018 in ODP.NET

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.

Answers

This discussion has been closed.