After 11g Upgrade, Receive Ora-38910 When Forall Query Has An Append Hint (Doc ID 759929.1)

Last updated on JULY 05, 2017

Applies to:

PL/SQL - Version 11.1.0.6 and later
Information in this document applies to any platform.
***Checked for relevance on 07-Feb-2013***

Symptoms

ORA-38910 occurring when doing a batch insert using an "/* APPEND */" hint after upgrade from 10.2
to 11.1

Testcase :

CREATE TABLE testdirect ( a INTEGER);

CREATE TYPE test_num_table IS TABLE OF NUMBER;
/

DECLARE
  testvals test_num_table := test_num_table(1,2,3,4,5,6,7,8,9);
BEGIN
  FORALL i IN testvals.FIRST .. testvals.LAST SAVE EXCEPTIONS
    INSERT /*+ append */ INTO testdirect
    VALUES (testvals (i));
END;
/

Error :

ORA-38910: BATCH ERROR mode is not supported for this operation
ORA-06512: at line 4



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms