SSC-FDM-OR0012

COMMIT and ROLLBACK statements require adequate setup to perform as intended.

Description

COMMIT and ROLLBACK statements require adequate setup to perform as intended in Snowflake. The following instruction needs to be executed in Snowflake to simulate the correct functionality of these statements:

ALTER SESSION SET AUTOCOMMIT = false;

Example Code

Input Code

IN -> Oracle_01.sql

COMMIT;
ROLLBACK;

Output Code

OUT -> Oracle_01.sql

--** SSC-FDM-OR0012 - COMMIT REQUIRES THE APPROPRIATE SETUP TO WORK AS INTENDED **
COMMIT;

--** SSC-FDM-OR0012 - ROLLBACK REQUIRES THE APPROPRIATE SETUP TO WORK AS INTENDED **
ROLLBACK;

Recommendations

• Execute the query mentioned in the description section before you start to execute your code.

• If you need more support, you can email us at [e-mail].