Value length exceeds the parameter size

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
t0pdevice
Posts: 4
Joined: Mon 07 Aug 2017 07:19

Value length exceeds the parameter size

Post by t0pdevice » Thu 12 Apr 2018 09:27

Hello.
How can I fix the error? In Oracle, the function has an argument of type varhar2, 3150 bytes are passed to the input.

Code: Select all

Message:     Value length exceeds the parameter size
Source:      Devart.Data.Oracle
StackTrace:
   в Devart.Data.Oracle.OracleParameter.a(OracleDbType A_0, Object A_1, Object A_2, Byte[] A_3, Hashtable A_4, Int32 A_5, Int32 A_6, Int32 A_7, Int32 A_8, Int32 A_9, Boolean A_10, OracleConnection A_11, ParameterDirection A_12, OracleType A_13, b0 A_14, Boolean& A_15)
   в Devart.Data.Oracle.OracleParameter.a(b5& A_0, Boolean A_1, OracleConnection A_2, Byte[] A_3, Hashtable A_4, b0 A_5, Boolean& A_6, Int32 A_7)
   в Devart.Data.Oracle.OracleCommand.a(cr A_0, Int32 A_1, OracleParameterCollection A_2, b0 A_3, Boolean& A_4)
   в Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
   в Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
   в Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
   в System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   в System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   в System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   в Devart.Data.Oracle.OracleDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   в System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   в Stimulsoft.Report.Dictionary.StiDataAdapterHelper.Fill(StiDictionary dictionary, DbDataAdapter dataAdapter, DataTable dataTable, Boolean schemaOnly)

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Value length exceeds the parameter size

Post by Pinturiccio » Tue 17 Apr 2018 14:00

Please provide the DDL script of the function and all the objects used in this function, so that we could use it to create this function in an empty database.

Please also send us a small test project which reproduces the issue.

Post Reply