Oracle Error PLS-01709: value list of INSERT statement, if specified with value list rather than subquery, must be value specification

Oracle Error Message

PLS-01709: value list of INSERT statement, if specified with value list rather than subquery, must be value specification

Reason for the Error

In an INSERT statement, the insert value list, if specified with a value list rather than a subquery, must be value specifications, i.e. no compound expressions or column references. Sect 8.7.

Solution

None