How to fix the Oracle error PCC-01009: For hostlan = COB74, a SQL statement must be followed by ELSE or “.”?
In this post, you’ll learn more about the Oracle ErrorPCC-01009: For hostlan = COB74, a SQL statement must be followed by ELSE or “.” with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
PCC-01009: For hostlan = COB74, a SQL statement must be followed by ELSE or “.”
Reason for the Error PCC-01009: For hostlan = COB74, a SQL statement must be followed by ELSE or “.”
Cause: In a Pro*COBOL program, an EXEC SQL statement is followed by another statement in the same sentence. An EXEC SQL statement must be the last statement in a COBOL-74 sentence and so must be terminated by the keyword ELSE or a period.
How to fix the Error PCC-01009: For hostlan = COB74, a SQL statement must be followed by ELSE or “.” ?
You can fix this error in Oracle by following the below steps
Action: Change the program logic, making the EXEC SQL statement the last statement in the sentence.
Leave Your Comment