Text is getting trimmed beyond 4000 chars in a script block in Workflow on Oracle db instances - Known Error

Text is getting trimmed beyond 4000 chars in a script block in Workflow on Oracle db instances Description While creating script block in workflow with more than 4000 chars, no validation warning is provided that text with more than 4000 chars is not allowed in Oracle db.

The workflow will work fine as long as the instance is not provisioned with an Oracle DB, where the script content gets truncated to 4000 characters and thereby results in error/loss of functionality.

Integration Hub also truncates the value/script field on Oracle when scripts are greater than 4000 characters.

Flow Designer stores its scripts in the sys_variable_value table which honours the limit of 4000 characters on Oracle DB.

Steps to Reproduce

1. Create a script block in workflow and provide more than 4000 characters.

2. Save and observe the operation is successful without any warning message.

Workaround After carefully considering the severity and frequency of the issue, and the cost and risk of attempting a fix, it has been decided to not address this issue in any current or near future releases. We do not make this decision lightly, and we apologise for any inconvenience.

The workaround is to have the large script placed in a Script Include which will be called by the Workflow.