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
How to recover the Application and AFX after an unexpected database failure in RSA Identity Governance & Lifecycle Troubleshooting AFX Connector issues in RSA Identity Governance & Lifecycle RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide RSA Release Notes for RSA Authentication Manager 8.8 RSA Authentication Manager Upgrade Process
Don't see what you're looking for?
