You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Pass JSON as a startup parameter to ODI scenario

Question
41
Views
0
Comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!