How to fix the Oracle error PLS-00322: declaration of a constant ‘string’ must contain an initialization assignment?

In this post, you’ll learn more about the Oracle ErrorPLS-00322: declaration of a constant ‘string’ must contain an initialization assignment with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-00322: declaration of a constant ‘string’ must contain an initialization assignment

Reason for the Error PLS-00322: declaration of a constant ‘string’ must contain an initialization assignment

A constant declaration lacks the assignment of an initial value. For example, in the following declaration” := 3.14159″ is the initialization clause: “pi constant number := 3.14159;”

How to fix the Error PLS-00322: declaration of a constant ‘string’ must contain an initialization assignment ?

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

Correct the constant declaration by supplying the missing initialization assignment.