How to fix the Oracle error LFI-00121: Only one of REPLACE, or PROT allowed for opty.?

In this post, you’ll learn more about the Oracle ErrorLFI-00121: Only one of REPLACE, or PROT allowed for opty. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

LFI-00121: Only one of REPLACE, or PROT allowed for opty.

Reason for the Error LFI-00121: Only one of REPLACE, or PROT allowed for opty.

Two or more of the following open type options were specified for the lfilini() function: LFILOPTY_REPLACE, or LFILOPTY_PROT.

How to fix the Error LFI-00121: Only one of REPLACE, or PROT allowed for opty. ?

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

Remove one or more the of options such that you are only passing in one of the three.