SAS Intelligent Decisioning Code File writing to Oracle Database with LONG or CLOB data type

[JAE2019]

Hi Experts!

We have a Data Query code file in SAS Intelligent Decisioning that writes to an Oracle Database. One string variable is being written to a variable with CLOB data type in Oracle, since its values will go beyond the 4000 limit of VARCHAR.

It works when we do the insert statement via SAS Studio, but testing the code file from the SCORING tab of a Decision Flow in SAS ID deems that it's unable to write to the table. Same thing happens when we publish to MAS - it's also unable to write to the table.

Is there any CAS / MAS related limitation to writing to a CLOB variable in Oracle? We encounter the same problem for writing to variables in Oracle with LONG data type. Attached is a portion of the logs for reference.

Hoping to get some guidance regarding this error

Thank you!!!

[konsri]

We use code as below when executing.

dcl package sqlstmt _stmt("query");

_stmt.setVarchar      to bind the value.

Try as above to reproduce. Maybe setVarchar is failing in this case.