How to fix the Oracle error PLS-00613: only one item is allowed, when using variables of record type?

In this post, you’ll learn more about the Oracle ErrorPLS-00613: only one item is allowed, when using variables of record type with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-00613: only one item is allowed, when using variables of record type

Reason for the Error PLS-00613: only one item is allowed, when using variables of record type

You are trying to use more than one values in VALUES clause or RETURNING INTO clause, when one of the value is of record type..

How to fix the Error PLS-00613: only one item is allowed, when using variables of record type ?

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

Specify only one variable of record type, or don’t use variables of record type.