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

ORA-30686: no dispatcher accepted TCP/IP connection request

1 Answers  


SQL-02125: Connect error, can't get error text

1 Answers  


DGM-16903: Unable to connect to database

1 Answers  


ORA-09909: Malloc of scratch buffer failed.

1 Answers  


ORA-27043: unable to seek to beginning of file

1 Answers  






ORA-23428: job associated instance number string is not valid

1 Answers  


ORA-06255: NETNTT: cannot read pid of remote process

1 Answers  


ORA-02241: must of form EXTENTS (FILE <n> BLOCK <n> SIZE <n>, ...)

1 Answers  


PCC-02366: Command line argument MODE=ANSI may not be used with DBMS=V6

1 Answers  


ORA-25246: listen failed, the address string is an 8.0 style exception queue

1 Answers  


ORA-02717: osnpfs: incorrect number of bytes written

1 Answers  


ORA-24327: need explicit attach before authenticating a user

1 Answers  


Categories