How to fix the Oracle error PCC-00060: Both CURSOR and STATEMENT have AT clauses at line number of file string.?

In this post, you’ll learn more about the Oracle ErrorPCC-00060: Both CURSOR and STATEMENT have AT clauses at line number of file string. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-00060: Both CURSOR and STATEMENT have AT clauses at line number of file string.

Reason for the Error PCC-00060: Both CURSOR and STATEMENT have AT clauses at line number of file string.

Cause: Two AT clauses, one in a DECLARE STATEMENT statement, the other in a DECLARE CURSOR statement, pertain to the same SQL statement. The AT clause may be specified with either DECLARE STATEMENT or DECLARE CURSOR, but not with both.

How to fix the Error PCC-00060: Both CURSOR and STATEMENT have AT clauses at line number of file string. ?

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

Action: Remove the AT clause from one of the statements.