How to fix the Oracle error ORA-34804: (OCI12) The value of SQL host variable number is too long. Use the WIDE keyword for columns that may exceed number bytes.?

In this post, you’ll learn more about the Oracle ErrorORA-34804: (OCI12) The value of SQL host variable number is too long. Use the WIDE keyword for columns that may exceed number bytes. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-34804: (OCI12) The value of SQL host variable number is too long. Use the WIDE keyword for columns that may exceed number bytes.

Reason for the Error ORA-34804: (OCI12) The value of SQL host variable number is too long. Use the WIDE keyword for columns that may exceed number bytes.

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

How to fix the Error ORA-34804: (OCI12) The value of SQL host variable number is too long. Use the WIDE keyword for columns that may exceed number bytes. ?

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

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