How to fix the Oracle error PLS-00721: ‘string’ formed a non-REF mutually-dependent cycle with ‘string’?

In this post, you’ll learn more about the Oracle ErrorPLS-00721: ‘string’ formed a non-REF mutually-dependent cycle with ‘string’ with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-00721: ‘string’ formed a non-REF mutually-dependent cycle with ‘string’

Reason for the Error PLS-00721: ‘string’ formed a non-REF mutually-dependent cycle with ‘string’

This compilation was aborted because the library unit that was compiled would have formed a non-REF mutually-dependent cycle with some other library units. This happens when an attempt is made to compile types that have attributes of other types that may participate in a cycle with this type. Example: create type t1; create type t2 (a t1); create type t1 (a t2);

How to fix the Error PLS-00721: ‘string’ formed a non-REF mutually-dependent cycle with ‘string’ ?

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

Break the cycle (possibly by adding a REF or by using another type).