title: Error: ORA-06502: PL/SQL: numeric or value error: host bind array too small
body: <p>I want to understand when this oracle error occurs 'Error: ORA-06502: PL/SQL: numeric or value error: host bind array too small'</p>
  
  <p>I have a plsql block and it has a normal annonymus block which has DBMS_output.put_line and also has DBMS_output.put in a for loop and in the code its calls another package in for loop itself and the out variables  like success( as S) and errormessage (as err_msg) of package are displayed using DBMS_output.put and the out put gets printed for few records but suddenly a above  error occurs and blocks gets completed don't how this happemed. Can any one explain why such error occurs.</p>