ORA-42653
Error during schema generation: The maximum string size for the EXECUTE IMMEDIATE statement is exceeded. Use the 'standalone' option as the outputFormat in the configuration options to manually execute the generated SQL scripts.
Cause
The maximum allowed string size for the EXECUTE IMMEDIATE statement is exceeded. If the string size exceeds this limit, the statement will not be executed and an error message will be returned.
Action
Use the 'standalone' option as the outputFormat in the configuration options for DBMS_JSON_DUALITY.GENERATE_SCHEMA and DBMS_JSON_DUALITY.INFER_AND_GENERATE_SCHEMA when the generated string is longer than the maximum allowed size.