How to fix the Oracle error PCC-00106: RELEASE is an Oracle extension to the COMMIT and ROLLBACK statements?

In this post, you’ll learn more about the Oracle ErrorPCC-00106: RELEASE is an Oracle extension to the COMMIT and ROLLBACK statements with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-00106: RELEASE is an Oracle extension to the COMMIT and ROLLBACK statements

Reason for the Error PCC-00106: RELEASE is an Oracle extension to the COMMIT and ROLLBACK statements

Cause: An Oracle extension to the ANSI/ISO SQL standard was used. Specifically, the parameter RELEASE was used in a COMMIT or ROLLBACK statement. For example, the offending code might look like: EXEC SQL ROLLBACK RELEASE; This informational message is issued by the FIPS Flagger when FIPS=YES.

How to fix the Error PCC-00106: RELEASE is an Oracle extension to the COMMIT and ROLLBACK statements ?

You can fix this error in Oracle by following the below steps

Action: No action required. However, for ANSI/ISO compliance, do not use the parameter RELEASE;