Oracle Solution for Error ora-34804

Solution for Oracle Error ORA-34804

ORA-34804: (OCI12) The value of SQL host variable number

is too long. Use the WIDE keyword for columns that may exceed number

bytes.

What triggered the Error:

The host variable had a text value longer than the maximum SQL VARCHAR length

What should we do to fix it:

Use the WIDE keyword in the host variable specification, e.g. :WIDE OLAP_object_name