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

NID-00311: Control File string - modified

1 Answers  


ORA-29373: resource manager is not on

1 Answers  


ORA-19610: directory block string is corrupt

1 Answers  


ORA-37070: You may not execute OLAP DML programs in a parallel query session.

1 Answers  


ORA-29256: Cursor contains both regular and array defines which is illegal

1 Answers  






IMG-00583: output format does not support the specified compressionFormat

1 Answers  


ORA-01575: timeout waiting for space management resource

1 Answers  


ORA-02212: duplicate PCTFREE option specification

1 Answers  


QSM-01090: no query rewrite after view merging

1 Answers  


ORA-29541: class string.string could not be resolved

1 Answers  


ORA-12011: execution of string jobs failed

1 Answers  


NZE-28787: private key encryption failure

1 Answers  


Categories