Using API Ego_user_attrs_data_pub.process_user_attrs_data get Error ORA-03113, "No more data to read from socket"

(Doc ID 2366332.1)

Last updated on FEBRUARY 27, 2018

Applies to:

Oracle Product Hub - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Catalog items

When attempting to use API ego_user_attrs_data_pub.process_user_attrs_data to insert/update a User Defined Attribute,
the following error occurs.

ERROR
-----------------------
ORA-03113: end-of-file on communication channel
Process ID: 28570
Session ID: 288 Serial number: 10989


In SQL Developer this is displayed as "No more data to read from socket".


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
When using API ego_user_attrs_data_pub.process_user_attrs_data to insert/update a User Defined Attribute

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