UPDATE on Multiple VARRAY Columns Hangs in 19c
(Doc ID 2889560.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
User session hangs when running Update on Multiple VARRAY columns.
Example :-
UPDATE <Table_name> SET (<COLUMN1>,<COLUMN2>,<COLUMN3>) = (SELECT <COLUMN1>,<COLUMN2>,<COLUMN3> FROM .... WHERE ....)
Hang does not happen when updating single VARRAY Type column
Example :-
UPDATE <Table_name> SET (<COLUMN1>) = (SELECT <COLUMN1> FROM .... WHERE ....)
Killing session from database end does not work, need to kill from OS.
Changes
Database Upgrade to 19c
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 |