How to fix the Oracle error OCI-19204: Non-scalar value ‘string’ is marked as XML attribute?

In this post, you’ll learn more about the Oracle ErrorOCI-19204: Non-scalar value ‘string’ is marked as XML attribute with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

OCI-19204: Non-scalar value ‘string’ is marked as XML attribute

Reason for the Error OCI-19204: Non-scalar value ‘string’ is marked as XML attribute

Only scalar values (i.e. values which are not of object or collection type) can be marked as XML attribute,i.e. is prefixed by ‘@’. In this case, a non-scalar value was prefixed with ‘@’

How to fix the Error OCI-19204: Non-scalar value ‘string’ is marked as XML attribute ?

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

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