Wednesday, September 17, 2008

ORA-06502: PL/SQL: numeric or value error: host bind array too small

ORA-06502: PL/SQL: numeric or value error: host bind array too small

Solution:
255 characters via DBMS_OUTPUT.PUT_LINE results in the following error when run from 10.1 SQL*Plus or prior, when connected to a 10.2 database

We need to substring of 255 characters for the value passed in the dbms_output statement.

No comments: