dotConnect for Oracle - Devart.Data.Oracle.OracleException - ORA-00933: SQL command not properly ended

Devart.Data.Oracle.OracleException (0x80004005): ORA-00933: SQL command not properly ended was raised when I use MaxBatchSize. Versions:

- Devart.Data.Oracle.EFCore :10.4.235.8

- Devart.Data.Oracle :10.4.235

- EntityFrameworkCore: 8.0.13

Ex:

optionsBuilder.UseOracle(_oracleSessionManager.GetOrCreateOracleConnection(), options =>

{

options.MaxBatchSize(50);

});

- called SaveChangesAsynch

await UseTransaction(response.ContextBag,

async () =>

{

await AggregateRepository.SaveChangesAsync();

}

);

-then SQL is generated in the VS Output:

[Error] Failed executing DbCommand ("14"ms) [Parameters=["p0='123456789' (DbType = Decimal), p1=NULL, p2=NULL, p3=NULL, p4=NULL, p5=NULL, p6=NULL, p7=NULL, p8=NULL, p9=NULL, p10=NULL, p11=NULL, p12=NULL, p13=NULL, p14=NULL (DbType = Int32), p15=NULL, p16=NULL, p17=NULL, p18=NULL, p19=NULL (DbType = Decimal), p20=NULL (DbType = Decimal), p21=NULL (DbType = DateTime), p22=NULL (DbType = DateTime), p23=NULL (DbType = DateTime), p24=NULL (DbType = DateTime), p25='1234567891111' (Nullable = true) (DbType = Decimal), p26='0' (Nullable = true) (DbType = Decimal), p27=NULL (DbType = Int32), p28='0' (Nullable = true), p29='121212121212121' (Nullable = true) (DbType = Decimal), p30='33333333333' (Nullable = true) (DbType = Decimal), p31='2025-10-09T00:00:00.0000000' (Nullable = true) (DbType = DateTime), p32='0' (Nullable = true), p33='3' (Nullable = true), p34='2025-10-02T00:00:00.0000000' (Nullable = true) (DbType = DateTime), p35='1' (Nullable = true), p36='2025-10-02T10:16:22.7820902' (Nullable = true) (DbType = DateTime), p37='1' (Nullable = true), p38=NULL (DbType = DateTime), p39=NULL (DbType = Decimal), p40=NULL, p41=NULL (DbType = Decimal), p42='0' (DbType = Decimal), p43=NULL, p44=NULL, p45=NULL, p46=NULL (DbType = Int32), p47=NULL, p48=NULL (DbType = DateTime), p49='0' (Nullable = true) (DbType = Decimal), p50='999' (Nullable = true) (DbType = Decimal), p51='0' (Nullable = true) (DbType = Decimal), p52=NULL (DbType = Decimal), p53=NULL, p54=NULL (DbType = Int32), p55='1' (Nullable = true), p56='1' (Nullable = true), p57=NULL (DbType = Int32), p58=NULL (DbType = DateTime), p59=NULL (DbType = DateTime), p60=NULL (DbType = Decimal), p61=NULL, p62='689814697538758' (Nullable = true) (DbType = Decimal), p63=NULL, p64='999' (Nullable = true) (DbType = Decimal), p65='0' (Nullable = true) (DbType = Decimal), p66=NULL (DbType = Decimal), p67=NULL (DbType = DateTime), p68=NULL (DbType = DateTime), p69=NULL, p70=NULL, p71=NULL (DbType = Int32), p72='0' (Nullable = true) (DbType = Decimal), p73=NULL (DbType = Decimal), p74=NULL (DbType = Decimal), p75='0' (Nullable = true) (DbType = Decimal), p76='0' (Nullable = true), p77=NULL, p78='999' (Nullable = true) (DbType = Decimal), p79='0' (Nullable = true) (DbType = Decimal), p80=NULL (DbType = Decimal), p81='0' (Nullable = true) (DbType = Decimal), p82='121212145454' (Nullable = true) (DbType = Decimal), p83=NULL (DbType = Int32), p84=NULL (DbType = Decimal), p85=NULL, p86='2222222222' (DbType = Decimal), p87=NULL (DbType = Int32), p88=NULL (DbType = Int32), p89=NULL (DbType = Int32), p90=NULL (DbType = Decimal), p91=NULL (DbType = Double), p92=NULL (DbType = Double), p93=NULL (DbType = Double), p94=NULL (DbType = Double), p95=NULL (DbType = Double), p96=NULL (DbType = Double), p97=NULL (DbType = Decimal), p98='49.95' (Nullable = true), p99=NULL (DbType = Decimal), p100='1234567891111' (Nullable = true) (DbType = Decimal), p101='0' (Nullable = true), p102='0' (Nullable = true), p103='1111111111' (Nullable = true) (DbType = Decimal), p104='0' (DbType = Decimal), p105='55555544444' (DbType = Decimal), p106='1', p107=NULL, p108=NULL, p109=NULL, p110=NULL, p111=NULL, p112='999' (DbType = Decimal), p113=NULL, p114=NULL, p115='123456789' (DbType = Decimal), p116=NULL (DbType = Decimal), p117='1' (Nullable = true), p118='1' (Nullable = true), p119=NULL (DbType = Decimal), p120=NULL (DbType = Int32), p121='999' (DbType = Decimal), p122=NULL (DbType = Int32), p123=NULL (DbType = Int32), p124=NULL (DbType = Int32), p125='2' (Nullable = true), p126='0' (Nullable = true), p127=NULL, p128=NULL (DbType = Int32), p129=NULL, p130='3333333333' (DbType = Decimal), p131=NULL (DbType = Int32), p132=NULL (DbType = Int32), p133=NULL (DbType = Int32), p134=NULL (DbType = Decimal), p135=NULL (DbType = Double), p136=NULL (DbType = Double), p137=NULL (DbType = Double), p138=NULL (DbType = Double), p139=NULL (DbType = Double), p140=NULL (DbType = Double), p141=NULL (DbType = Decimal), p142='0' (Nullable = true), p143=NULL (DbType = Decimal), p144='1234567891111' (Nullable = true) (DbType = Decimal), p145='0' (Nullable = true), p146='0' (Nullable = true), p147='5555555555' (Nullable = true) (DbType = Decimal), p148='0' (DbType = Decimal), p149='444444444' (DbType = Decimal), p150='2', p151=NULL, p152=NULL, p153=NULL, p154=NULL, p155=NULL, p156='999' (DbType = Decimal), p157=NULL, p158=NULL, p159='123456789' (DbType = Decimal), p160=NULL (DbType = Decimal), p161='2' (Nullable = true), p162='1' (Nullable = true), p163=NULL (DbType = Decimal), p164=NULL (DbType = Int32), p165='999' (DbType = Decimal), p166=NULL (DbType = Int32), p167=NULL (DbType = Int32), p168=NULL (DbType = Int32), p169='2' (Nullable = true), p170='0' (Nullable = true), p171=NULL, p172=NULL (DbType = Int32), p173='B' (Size = 1)"], CommandType='Text', CommandTimeout='0']"

""INSERT INTO ORDER_GROUPS (ORDER_GROUP_ID, ADDRESS1, ADDRESS2, ADDRESS3, BUILDING_NAME, COUNTRY, COUNTY, EMAIL, FLAT_NUMBER, FLOOR_NUMBER, FULL_NAME, HOME_TELEPHONE, MOBILE, POST_CODE, POSTCODE_LKRESULT, STREET_NUMBER, STREET_TYPE, TOWN, WORK_TELEPHONE, CENTRAL_ORDER_ID, CHASE_INFORMED, CHECKED_DATE, CHECKED_TIME, COLLECTED_DATE, COLLECTED_TIME, CREATED_BY, CUSTOMER_INFORMED, DELIVERY_MODE, DELIVERY_STATUS, DISPENSE_GROUP_ID, DISPENSE_ID, DUE_DATE, FRAME_PICKED, FRAME_STATUS, GROUP_DATE, GROUP_STATUS, GROUP_TIME, GROUP_TYPE, INFORMED_DATE, INVOICE_ID, INVOICE_NUMBER, INVOICED, RECORD_DELETED, LAB_REFERENCE, LAB_REJECTION_CODE, LAB_REJECTION_TEXT, LAB_STATUS_CODE, LAB_STATUS_TEXT, LAST_CHASED, L_PRECAL, LOCATION_ID, ORDER_ACKNOWLEDGED, ORDER_ID, ORDER_SCHEDULE, ORDER_SOURCE, ORDER_TYPE, ORDER_VISIBLE, ORDERED_COUNT, ORDERED_DATE, ORDERED_TIME, ORIGINAL_ORDER_ID, ORIGINAL_PO, PID, PO_NUMBER, PRACTICE_ID, PRIORITY, PROCESSED_BY_OCP, RECEIVED_DATE, RECEIVED_TIME, REFERENCE, REMAKE_EXPLAINATION, REMAKE_FAULT, REMAKE_ORDER, REMAKE_REASON_ID, RETURN_REASON_ID, R_PRECAL, SHIP_EXTERNAL, SHIP_INSTRUCTIONS, SHIP_STORE_ID, SPECIAL_ORDER_FRAME, SPECIAL_ORDER_PLACED, STOCK_ORDER, SUPPLIER_ID, SUPPLIER_STATUS, TRANSPORT_NUMBER, TRANSPORT_REFERENCE)

VALUES (:p0, :p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10, :p11, :p12, :p13, :p14, :p15, :p16, :p17, :p18, :p19, :p20, :p21, :p22, :p23, :p24, :p25, :p26, :p27, :p28, :p29, :p30, :p31, :p32, :p33, :p34, :p35, :p36, :p37, :p38, :p39, :p40, :p41, :p42, :p43, :p44, :p45, :p46, :p47, :p48, :p49, :p50, :p51, :p52, :p53, :p54, :p55, :p56, :p57, :p58, :p59, :p60, :p61, :p62, :p63, :p64, :p65, :p66, :p67, :p68, :p69, :p70, :p71, :p72, :p73, :p74, :p75, :p76, :p77, :p78, :p79, :p80, :p81, :p82, :p83, :p84, :p85)

INSERT INTO ORDER_ITEMS (ORDER_ITEM_ID, BRAND_ORDERED, BRAND_SOLD, BRAND_STOCK, CENTRAL_ORDER_ID, CL_ADD, CL_AXIS, CL_BASE_CURVE, CL_CYLINDER, CL_DIAMETER, CL_SPHERE, CL_TYPE_ID, COST_PRICE, COST_PRICE2, CREATED_BY, DELIVERED_QUANTITY, DELIVERY_STATUS, DISPENSE_ITEM_ID, RECORD_DELETED, ITEM_ID, ITEM_TYPE, KIT_INFO, LAB_REJECTION_CODE, LAB_REJECTION_TEXT, LAB_STATUS_CODE, LAB_STATUS_TEXT, LOCATION_ID, MOUNT_PROGRESSIVE, NOTES, ORDER_GROUP_ID, ORDER_ID, ORDER_QUANTITY, ORDER_STATUS, ORIGINAL_ORDER_ID, ORIGINAL_QTY, PRACTICE_ID, PRODUCT_ORDERED, PRODUCT_RESERVED, PRODUCT_SOLD, RECORD_TYPE, REORDER_STATUS, SEASON_CODE, TARGET_QUANTITY, ITEM_EYE)

VALUES (:p86, :p87, :p88, :p89, :p90, :p91, :p92, :p93, :p94, :p95, :p96, :p97, :p98, :p99, :p100, :p101, :p102, :p103, :p104, :p105, :p106, :p107, :p108, :p109, :p110, :p111, :p112, :p113, :p114, :p115, :p116, :p117, :p118, :p119, :p120, :p121, :p122, :p123, :p124, :p125, :p126, :p127, :p128, :p129)

VALUES (:p130, :p131, :p132, :p133, :p134, :p135, :p136, :p137, :p138, :p139, :p140, :p141, :p142, :p143, :p144, :p145, :p146, :p147, :p148, :p149, :p150, :p151, :p152, :p153, :p154, :p155, :p156, :p157, :p158, :p159, :p160, :p161, :p162, :p163, :p164, :p165, :p166, :p167, :p168, :p169, :p170, :p171, :p172, :p173)

Note that after the table insert there was no semi-colon between the insert statements.

- then it generates the error:

"Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details.

---> Devart.Data.Oracle.OracleException (0x80004005): ORA-00933: SQL command not properly ended

at Devart.Data.Oracle.dq.a(ay A_0, Int32 A_1)

at Devart.Data.Oracle.dq.a(Int32 A_0, bx A_1)

at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)

at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)

at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)

at Devart.Data.Oracle.Entity.at.b5(CommandBehavior A_0)

at Devart.Common.Entity.cs.ExecuteDbDataReader(CommandBehavior behavior)

at Devart.Data.Oracle.Entity.at.ExecuteDbDataReader(CommandBehavior behavior)

at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)