Oracle Error OCI-19205: Attribute ‘string’ qualifies a non-scalar value in the select list

Oracle Error Message

OCI-19205: Attribute ‘string’ qualifies a non-scalar value in the select list

Reason for the Error

The attribute immediately follows a value of object or collection type in the select list or type definition.

Solution

Remove the ‘@’ sign, or make the previous value a scalar.