Does RSA Identity Governance and Lifecycle MAX_STRING_SIZE need to be modified from STANDARD to EXTENDED to accommodate strings longer than 4000 bytes?
Originally Published: 2017-08-07
Article Number
Applies To
RSA Version/Condition: 7.0.2
Product Name: Oracle 12c
Issue
Should this setting be modified from STANDARD to EXTENDED in RSA Identity Governance and Lifecycle?
Resolution
MAX_STRING_SIZE=STANDARD
Explanation
Long before Oracle 12c, Oracle has allowed PL/SQL variables to be declared at 32767 bytes in length. However, this does not apply to DML and/or DDL.From the Oracle documentation on PL/SQL datatypes:
Although PL/SQL character variables can be relatively long, the maximum width of a VARCHAR2 database column is 4000 bytes. So, you cannot insert VARCHAR2 values longer than 4000 bytes into a VARCHAR2 database column.
Therefore, just because we define PL/SQL variables > 4000, it does not mean we want DML/DDL variables to be > 4000.
Reasons not to change the setting
The MAX_STRING_SIZE parameter is an irreversible change and needs some careful evaluation on how it might affect the functionality of the product. Furthermore, not all RSA Identity Governance and Lifecycle customers might be willing to make the switch, so RSA would need to get their opinions first. Finally, exceeding the limit of 4000 characters usually points to a badly designed functionality that needs to be fixed, instead of working around the problem and waiting for the 32K limit to be reached later on.Official RSA recommendation
If you experience a problem for which you think this setting should be modified, please report the problem and have an official fix delivered without changing MAX_STRING_SIZE.
Related Articles
Do Web Services need to be enabled if they are not being used in RSA Identity Governance & Lifecycle? Number of Views How to run the RSA AMBA utility without the need of input files? Number of Views When is a wildcard certificate needed in RSA SecurID Access? Number of Views MFA Agent for Windows v2.3 Upgrade Is Paused by Error "The following applications are using files that need to be updated" Number of Views Need to wait until updating radius_connector.ini file after AM8.6 upgrades replica side Number of Views
Trending Articles
Passwordless Authentication in Windows MFA Agent for Active Directory – Quick Setup Guide RSA Authentication Manager 8.9 Release Notes (January 2026) RSA Authentication Manager Upgrade Process RSA Authentication Manager 8.7 SP2 Setup and Configuration Guide An example of SSO using SAML and ADFS with RSA Identity Management and Governance 6.9.x
Don't see what you're looking for?
