Pass JSON as a startup parameter to ODI scenario

Summary:

Hi team,

We have a requirement to generate a JSON request in ODI, pass it to an API and log the same request details in a database table. We created an ODI procedure for the logging, generated a scenario and passed the JSON object (Text variable) as a startup parameter to the scenario. Although the column in the database table is a CLOB, the incoming (JSON) variable is treated as character by the ODI procedure and we get the error - ORA-1704: string literal too long. Is there any way to pass a JSON/CLOB object to an ODI scenario or any other