Improve the following message: "To resolve the issue, please follow these steps:
# Execute the provided script.
# Incorporate the ALTER SESSION portions of the script (excluding the schema recompilation) into your procedure before running any RS2 updates, as well as any non-RS2 updates that include PL/SQL code.

Script:
{code:sql}
alter session set plsql_compiler_flags = 'NATIVE';
alter session set plsql_optimize_level = 2;
alter session set plsql_debug = false;
alter session set nls_length_semantics = char;
exec dbms_utility.compile_schema('BW3', true);
{code}

Cause:
The default value for the oracle length is set to byte which results in a discrepancy of expected logic since we set the varchar2 limits to the character length.
This solution simply sets such default byte length to Char.

Example of what was happening:
We were trying to load a 17 char Hebrew text to a column {{TRADE_NAME_L2}} which is set as {{VARCHAR2(25)}}.
The byte length of such text was 31 bytes, this caused Oracle to output the error shown abouve in [~NAME_1.NAME_2]'s comment.

[~NAME_1.NAME_2], kindly relay this information to the client.". The word "message" should not appear in your response.
user