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


PCC-00079: ANSI requires colon on label in WHENEVER statement



PCC-00079: ANSI requires colon on label in WHENEVER statement..

Answer / guest

Cause: An Oracle extension to the ANSI/ISO SQL standard was
used. Specifically, an alphanumeric WHENEVER ... GOTO label
was not prefixed with a colon. For example the offending
code might look like: EXEC SSQL WHENEVER NOT FOUND GOTO
no_more; This informational message is issued by the FIPS
Flagger when FIPS=YES.

Action: No action required. However, for ANSI/ISO
compliance, prefix alphanumeric (but not numeric) WHENEVER
... GOTO labels with a colon.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

TNS-12547: TNS:lost contact

1 Answers  


IMP-00095: Resumable parameters ignored -- current session not resumable

1 Answers  


AMD-00120: dimension #string: analytic workspace dimension name not specified

1 Answers  


NPL-00310: ASN.1 sequence has already been ended on read

1 Answers  


ORA-38453: ExpFilter index should be created in the same schema as the base table.

1 Answers  






ORA-26571: %s.string.string: number of arguments (string) does not match replication catalog

1 Answers  


ORA-00394: online log reused while attempting to archive it

1 Answers  


TNS-01081: Started with pid=string

1 Answers  


ORA-37077: (XSMCSESS05) Object workspace object is specified more than once.

1 Answers  


ORA-13863: Statistics aggregation for service(module/action) string is not enabled

1 Answers  


ORA-00213: cannot reuse controlfile; old file size string, string required

1 Answers  


ORA-01264: Unable to create string file name

1 Answers  






Categories