Open issues

ora-24816: expanded non LONG bind data supplied after actual LONG or LOB column
NH-4012
Redesign types + introduce TypeRegistry & TypeResolver
NH-3989
HiLo optimizer for enhanced TableGenerator not Generating next value correctly when called from different processes
NH-3880
Potentially serious memory leak with regards to AdoTransaction Rollback
NH-3870
Follow up Hibernate
NH-3617
NHibernate 2nd Level Cache remains updated after rollback
NH-3508
Stale data checking does not work for one-to-one associations.
NH-3288
QueryOver with constants does only execute projections at the beginning of the select
NH-3028
ISQLQuery - SetParameter doesn't work with more than 10 parameters
NH-4053
Port changes from HHH-9490 concerning hbm2ddl tool
NH-3979
Method 'SomeClass.Add_callback' does not have a method body
NH-3965
Invalid SQL generated
NH-3928
ORA-00904: "THIS_"."ID" when combining SetMaxResults and SetLockMode in single query
NH-3902
On high load blocked by: Npgsql connection pool has been exhausted, either raise MaxPoolSize or timeout
NH-3896
Keys with custom GetHashCode are not added correctly to key-many-to-many/one-to-many dictionaries when FetchMode is not Select
NH-3894
HQL parse error of a query with 'left' or 'right' function
NH-3893
Linq Query incorrect when using & operator
NH-3887
Unable to resolve property: _{Namespace} during Merge
NH-3886
EntityLoader ignores subselect fetching option
NH-3872
Schema Update Failure
NH-3867
Exception when calling First on a GroupBy Query
NH-3859
using Skip(aNumber).Count() where aNumber is greater than total count of records results in ArgumentOutOfRangeException
NH-3851
DynamicUpdate and OnPreUpdate not udates
NH-3843
String methods StartsWIth, EndsWith and Contains should generate LIKE statement with escape character
NH-3829
Batch saving entities with proxy associations leads to fetching all associated entities
NH-3806
NHibernate TypeFactory unable to instantiate Hibernate.Type.StringType
NH-3796
generating sql comand "Having" with two conditions
NH-3789
Error between 2 lists by Any() and StartsWith()
NH-3786
Improve performance of NHibernate.Loader.TopologicalSorter
NH-3777
SchemaExport for Sqlite creates invalid primary key
NH-3758
MySQL Schema Update Doesn't Work
NH-3733
Document Mapping By Code
NH-3730
Update Documentation
NH-3729
Deprecate utility functionality
NH-3678
SchemaExport for Sqlite creates invalid foreign keys
NH-3664
META: Resolve issues with many-to-one and filters
NH-3653
Permit scalar functions inside count() aggregate function
NH-3645
A <bag> collection with composite-id is not been fetched on version 3.x.x
NH-3643
Inner Join on reffered entities in union-subclass should work correct
NH-3640
Fetching in query causes incorrect/missing joins in subquery
NH-3622
LINQ/HQL problems with CollectionFetchMode.Subselect with Skip and Take
NH-3616
session load exception with enableFilter
NH-3576
Insert + delete collection item issue using versioned parent
NH-3570
IQueryable<T> implementation failes with OData $expand operation used againt collection with TypeMismatchException
NH-3556
Cascade of "all-delete-orphan" not supported for detached entities
NH-3551
BasicFormatter throws exceptions for certain types of data containing "signal words"
NH-3549
Enhanced Db2 driver to support multi query
NH-3543
DistinctRootEntityResultTransformer and AddJoin not working properly below collections
NH-3542
DistinctRootEntityResultTransformer only works properly for linear chains
NH-3538
Allow mapping of temporary tables
NH-3537
issue 1 of 503

ora-24816: expanded non LONG bind data supplied after actual LONG or LOB column

Description

While updating it throws the error:

1 2 3 4 5 6 7 8 9 10 11 Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column at OracleInternal.ServiceObjects.OracleCommandImpl.VerifyExecution(OracleConnectionImpl connectionImpl, Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone) at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteNonQuery(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, OracleException& exceptionForArrayBindDML, Boolean isFromEF) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery() at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(IDbCommand cmd) ERROR 2017-04-09 08:59:58,272 461541 NHibernate.AdoNet.AbstractBatcher - p243438 - 10.1.24.110 - /Epolice/Incident/Edit/cb2f4794-545e-4b47-83dd-a748009fb20c - Could not execute command: UPDATE ep_Incident SET Completed = :p0, FollowupStatus = :p1, InactiveDate = :p2, ActionPlan = :p3, StatusChangedBy = :p4, StatusChangedBySignatureId = :p5, RegistrationTypeId = :p6, ComplaintMethodId = :p7, SecurityLevelId = :p8, IncidentDate = :p9, ReportedDate = :p10, LocationAroundCrimeId = :p11, VillageId = :p12, BuildingNo = :p13, WayNumber = :p14, Coordinates_North = :p15, Coordinates_East = :p16, IncidentSummary = :p17, IncidentDetails = :p18, BlockNumber = :p19, Square = :p20, RoadName = :p21, WayTypeId = :p22, ProcedureIncident = :p23, PoliceStationId = :p24, CreatedInPoliceStationId = :p25, TransactionId = :p26, ModifiedDate = :p27, ModifiedBy = :p28, IsDeleted = :p29, AccidentSceneDrawnUserId = :p30, AccidentSceneDrawnSignatureId = :p31, AccidentSceneDescription = :p32, WeatherConditionsId = :p33, AccidentTypeId = :p34, AccidentPrimaryReasonId = :p35, OtherReasons = :p36, TrafficAccidentLocationId = :p37, AccidentDetails = :p38, LocationDetails = :p39, AccidentLevel = :p40, BeforeAccident = :p41, DuringAccident = :p42, AfterAccident = :p43, CrashSeverityId = :p44, NoOfVehicleInvolved = :p45, NoOfCasualityKilled = :p46, NoOfCasualityInjured = :p47, RoadSpeed = :p48, JunctionTypeId = :p49, RoadWorks = :p50, RoadCategoryId = :p51, RoadTypeId = :p52, RoadFeaturesId = :p53, RoadShapesId = :p54, RoadLightingControlsId = :p55, PhysicalSurfaceConditionId = :p56, RoadSurfaceStatesId = :p57, ShoulderTypeId = :p58, ShoulderConditionId = :p59, IsCentralDividerPresent = :p60, LightConditionId = :p61, SurfaceTypeId = :p62, CarriagewayWidth = :p63, ShoulderWidth = :p64, NoOfLines = :p65, TrafficOffenceId = :p66, TrafficRestrictionId = :p67, RoadLengthKM = :p68, RoadLength100M = :p69 WHERE Id = :p70 Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column at OracleInternal.ServiceObjects.OracleCommandImpl.VerifyExecution(OracleConnectionImpl connectionImpl, Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone) at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteNonQuery(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, OracleException& exceptionForArrayBindDML, Boolean isFromEF) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery() at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(IDbCommand cmd)

According to this link the cause should be:

1 2 3 ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column Cause: A Bind value of length potentially > 4000 bytes follows binding for LOB or LONG. Action: Re-order the binds so that the LONG bind or LOB binds are all at the end of the bind list.

Any thoughts? I am not aware of NHibernate source code to provide a PR for this.

Environment

Windows 64 bit and backend is Orace 11g

Status

Assignee

Unassigned

Reporter

anwer matter