How to fix the Oracle error PLS-00709: pragma string must be declared in package specification and body?

In this post, you’ll learn more about the Oracle ErrorPLS-00709: pragma string must be declared in package specification and body with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-00709: pragma string must be declared in package specification and body

Reason for the Error PLS-00709: pragma string must be declared in package specification and body

The named pragma was declared in a package specification but not in the corresponding package body or vice-versa, as well as the package body.

How to fix the Error PLS-00709: pragma string must be declared in package specification and body ?

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

Add the pragma to that part of the package declaration that does not have the pragma.

Tags :

Leave Your Comment