MSCEWI3021

SQL implicit cursor values may differ.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Low

Description

This EWI is shown when SQL implicit cursor value is used. This is because Oracle uses different values depending on the type of query. For example, for SELECT the value used to set SQL implicit cursor values are the number of rows returned by the query. When the query type is UPDATE/CREATE/DELETE/INSERT the value used is the number of rows affected, this is the main reason why this EWI is displayed.

Example Code

Input Code:

EXECUTE IMMEDIATE 'INSERT INTO FTABLE33 VALUES(:D0, :D1,:D2,:D3,:D4)' USING STMT, SQL%ROWCOUNT, STMT_STAT1, STMT_STAT2, STMT_STAT3;

Output Code:

EXEC(`INSERT INTO PUBLIC.FTABLE33 VALUES(?, ?, ?, ?, ?)`,[STMT,SQL.ROWCOUNT /*** MSC-WARNING - MSCEWI3021 - SQL IMPLICIT CURSOR VALUES MAY DIFFER ***/,STMT_STAT1,STMT_STAT2,STMT_STAT3]);

Recommendations

• No additional user actions are required.

• If you need more support, you can email us at [email protected]