Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



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

Answer / guest

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.

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-29831: operator binding not found

1 Answers  


ORA-02187: invalid quota specification

1 Answers  


NZE-29120: Cannot export certificate.

1 Answers  


ORA-24121: both cascade and a block range passed to DBMS_REPAIR.CHECK_OBJECT procedure

1 Answers  


ORA-22855: optional name for LOB storage segment incorrectly specified

1 Answers  






LPX-00302: Incorrect stylesheet. The node is not valid.

1 Answers  


ORA-24408: could not generate unique server group name

1 Answers  


ORA-38601: FI Not enough memory for frequent itemset counting: string

1 Answers  


NCR-04010: NCRR: Unable to contact Oracle Names Server

1 Answers  


PCC-00032: Invalid option "string"

1 Answers  


ORA-07219: slspool: unable to allocate spooler argument buffer.

1 Answers  


TNS-01188: Listener cannot operate with incompatible transport protocols

1 Answers  






Categories