In this post, you’ll learn more about the Oracle ErrorPLS-00519: This INSERT statement requires a VALUES clause containing an object type expression, not a list of values with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
PLS-00519: This INSERT statement requires a VALUES clause containing an object type expression, not a list of values
Reason for the Error PLS-00519: This INSERT statement requires a VALUES clause containing an object type expression, not a list of values
In an INSERT statement with typed tables, an aggregate was used when an object type item was expected.
How to fix the Error PLS-00519: This INSERT statement requires a VALUES clause containing an object type expression, not a list of values ?
You can fix this error in Oracle by following the below steps
Replace the aggregate with an object constructor or other object type expression.