My Oracle Support Banner

ORA-38104: Columns Referenced In The ON Clause Cannot Be Updated: (Doc ID 2702986.1)

Last updated on APRIL 06, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 18.9.0.0.0 [Release 12.1 to 18]
Information in this document applies to any platform.

Symptoms

After applying patch for Bug 27276231 - ARCHIVED ROWS VISIBLE IN PLSQL EVEN WITH PATCH 23080557 APPLIED Bug 27276231 - ARCHIVED ROWS VISIBLE IN PLSQL EVEN WITH PATCH 23080577 APPLIEDBug 27276231 - ARCHIVED ROWS VISIBLE IN PLSQL EVEN WITH PATCH 23080557 APPLIED Bug 27276231 - ARCHIVED ROWS VISIBLE IN PLSQL EVEN WITH PATCH 23080557 APPLIED Bug 27276231 - ARCHIVED ROWS VISIBLE IN PLSQL EVEN WITH PATCH 23080557 APPLIED Bug 27276231 - ARCHIVED ROWS VISIBLE IN PLSQL EVEN WITH PATCH 23080557 APPLIED Bug 27276231 - ARCHIVED ROWS VISIBLE IN PLSQL EVEN WITH PATCH 23080557 APPLIED Bug 27276231 - ARCHIVED ROWS VISIBLE IN PLSQL EVEN WITH PATCH 23080557 APPLIED 

MERGE INTO ARCH_TEST1 TARGET USING (
Select ID FROM ARCH_TEST1
Order by 1 FETCH FIRST 2 rows only
) SOURCE
ON (TARGET.ID = SOURCE.ID)
WHEN MATCHED THEN
UPDATE SET TARGET.ORA_ARCHIVE_STATE = '1';

ERROR at line 1:
ORA-38104: Columns referenced in the ON Clause cannot be updated: "TARGET"."ORA_ARCHIVE_STATE"

This same script works well in 12.1.0.2 (not patched with the merge patch provided), and 12.2.0.1.

Changes

 Applied patch 27276231

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.