In this post, you’ll learn more about the Oracle ErrorPCC-00028: Option “string” not legal as EXEC ORACLE OPTION with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
PCC-00028: Option “string” not legal as EXEC ORACLE OPTION
Reason for the Error PCC-00028: Option “string” not legal as EXEC ORACLE OPTION
Cause: A precompiler option was specified inline in an EXEC ORACLE statement. Some options can be specified only on the command line. For example, INAME cannot be specified inline.
How to fix the Error PCC-00028: Option “string” not legal as EXEC ORACLE OPTION ?
You can fix this error in Oracle by following the below steps
Action: Respecify the precompiler option on the command line, instead of in an EXEC ORACLE statement. To see an online display of the precompiler options, enter the precompiler command (with no options) at the operating-system prompt.