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.