Description
Steve Trautman created an issue — 17th July 2009, 14:02:47:
Using NHibernate-2.1.0.CR1, Oracle10gDialect, dynamic-insert="true" and a trigger-identity, the SQL generated is missing the "RETURNING Id INTO :nhIdOutParam" clause, causing an ORA-01036 error. Take out the dynamic-insert, and all is well.
The SQL generated is:
INSERT INTO DomainClass (Data) VALUES (:p0);:p0 = 'test', :nhIdOutParam = NULL
Steve Trautman added a comment — 17th July 2009, 14:30:11:
Attached is a zipped NHibernate.LiteTestSolution with a NH1893 test case (the dlls were removed from the solution before zipping).
Marc added a comment — 26th May 2015, 10:44:24:
I've the same problem using NHibernate-3.3.3SP1 and a custom dialect that inherits from Oracle10gDialect, any news about it?
Marc added a comment — 26th May 2015, 10:47:08:
Meanwhile I remove dynamic-insert from the mapping, but I've have a legacy database that contains tables with up to 180 columns, I need dynamic-insert please...