How to fix the Oracle error PLS-00230: OUT and IN OUT formal parameters may not have default expressions?

In this post, you’ll learn more about the Oracle ErrorPLS-00230: OUT and IN OUT formal parameters may not have default expressions with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-00230: OUT and IN OUT formal parameters may not have default expressions

Reason for the Error PLS-00230: OUT and IN OUT formal parameters may not have default expressions

When the formal parameters of a procedure were declared, an OUT or IN OUT parameter was initialized to a default value, as in PROCEDURE calc_bonus (bonus OUT REAL := 0, …) IS … However, only IN parameters can be initialized to default values.

How to fix the Error PLS-00230: OUT and IN OUT formal parameters may not have default expressions ?

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

Remove the illegal default expression.