How to fix the Oracle error PCB-00003: Value of DBMS option invalid with given value of MODE option?

In this post, you’ll learn more about the Oracle ErrorPCB-00003: Value of DBMS option invalid with given value of MODE option with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCB-00003: Value of DBMS option invalid with given value of MODE option

Reason for the Error PCB-00003: Value of DBMS option invalid with given value of MODE option

Cause: When MODE={ANSI14 | ANSI13}, DBMS=V7 or V8 was specified, or when MODE=ANSI, DBMS=v6 was specified. These option settings are incompatible. Note that the DBMS option was not available before release 1.5 of the Oracle Precompilers.

How to fix the Error PCB-00003: Value of DBMS option invalid with given value of MODE option ?

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

Action: With DBMS=V7 or V8, instead of MODE={ANSI14 | ANSI13}, specify MODE={ANSI | ORACLE}. With DBMS=V6, instead of MODE=ANSI, specify MODE={ANSI14 | ANSI13 | ORACLE}, but MODE=ORACLE is recommended.