ORA-38104: Columns Referenced In The ON Clause Cannot Be Updated:
(Doc ID 2702986.1)
Last updated on APRIL 17, 2023
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 |