Oracle Error PLS-01909: : cannot assign supertype instance to subtype

Oracle Error Message

PLS-01909: : cannot assign supertype instance to subtype

Reason for the Error

An attempt was made to assign or copy a supertype instance to a container (destination) that can only hold a subtype instance.

Solution

Make sure the runtime type of the source of the assignment or copy is the same type as the destination or is a subtype of the destination type