EGO_CHANGE_USER_ATTRS_PUB Program Fails With "ORA-6502 PL/SQL numeric Or Value Err: Char String Buffer Too Small"
Last updated on FEBRUARY 03, 2017
Applies to:Oracle Product Hub - Version 18.104.22.168 and later
Information in this document applies to any platform.
Error is generated by EGO_USER_ATTRS_DATA_PVT.Process_User_Attrs_Data when Debug is turned on.
On analysis we found that this is caused by the variable definition l_output_dir VARCHAR2(512); in the procedure EGO_USER_ATTRS_DATA_PVT.Set_Up_Debug_Session which is called by the API when it is invoked with debug level > 0. The length of the utl_file_dir in v$parameter where we are getting this error id 554 characters.
On further analysis we found that a similar issue was addressed by the Patch 10255150 which is related to version 22.214.171.124.
EBS Upgrade or Database Upgrade
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