oracle / oracle/dotnet-db-samples

ODP.NET bulk copy parallel loads feature request

Open
#463 16 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

enhancement
Dominant language
C#
Stars
434
Forks
191
Avg merge
1d 15h
Merged PRs (30d)
1

Description

When i use an APPEND_VALUES hint in my Insert command and execute it using ExecuteNonQuery i receive an error message :

Message : ORA-38910: BATCH ERROR mode is not supported for this operation
StackTrace :    at OracleInternal.ServiceObjects.OracleFailoverMgrImpl.OnError(OracleConnection connection, CallHistoryRecord chr, Object mi, Exception ex, Boolean bTopLevelCall, Boolean& bCanRecordNewCall)
   at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery()

is it possible to set off the the error verifications somewhere and if not, would it be possible to push the demand to dev team ?

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reproducing the reported error with an APPEND_VALUES hint and ExecuteNonQuery, then inspect the ODP.NET bulk-copy and batch-error behavior involved in ORA-38910. The issue names no repository files or tests; done would require an agreed implementation or documented support path for parallel bulk loads.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp
Domain
databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Quiet
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.