How to fix the Oracle error PLS-00318: type “string” is malformed because it is a non-REF mutually recursive type?

In this post, you’ll learn more about the Oracle ErrorPLS-00318: type “string” is malformed because it is a non-REF mutually recursive type with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-00318: type “string” is malformed because it is a non-REF mutually recursive type

Reason for the Error PLS-00318: type “string” is malformed because it is a non-REF mutually recursive type

A type-declaration such as: — a non-REF recursive type, for example: type t is record (a t); or — non-REF mutually dependent types, for example: type t1; type t2 is record (a t1); type t1 is record (a t2); was performed. In these examples, the type is malformed because it participates in a mutually recursive non-REF relationship with itself and possibly other types.

How to fix the Error PLS-00318: type “string” is malformed because it is a non-REF mutually recursive type ?

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

Use another type to remove the recursion.