How to fix the Oracle error PCC-02047: CMD-LINE: Option is not allowed inline:?

In this post, you’ll learn more about the Oracle ErrorPCC-02047: CMD-LINE: Option is not allowed inline: with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-02047: CMD-LINE: Option is not allowed inline:

Reason for the Error PCC-02047: CMD-LINE: Option is not allowed inline:

Cause: An option was entered inline that can only be entered on the command line or in a configuration file. For example, the offending code might look like EXEC ORACLE OPTION (NLS_CHAR=); The NLS_CHAR option can only be entered on the command line or in a configuration file.

How to fix the Error PCC-02047: CMD-LINE: Option is not allowed inline: ?

You can fix this error in Oracle by following the below steps

Action: Remove the option from the source file, and specify it on the command line.