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

JAE2019 — Fri, 17 Feb 2023 06:33:29 GMT

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!!!

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

konsri — Wed, 22 Feb 2023 17:42:37 GMT

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.

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

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

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