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

Oracle Error Message

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

Reason for the Error

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.

Solution

Use another type to remove the recursion.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message ORA-24328: illegal attribute value Reason for the Error The attribute value passed in is illegal. Solution Consult...
Oracle Error Message ORA-01346: LogMiner processed redo beyond specified reset log scn Reason for the Error LogMiner has detected a...
Oracle Error Message ORA-13241: specified dimensionality does not match that of the data Reason for the Error An error occurred...