Oracle Error Message
ORA-06566: invalid number of rows specified
Reason for the Error
An invalid number of rows was specified in a call to the procedure DEFINE_COLUMN in the package DBMS_SQL. For a given parsed statement in a given cursor, all columns must be defined to have the same number of rows, so all the calls to DEFINE_COLUMN must specify the same number of rows.
Solution
Specify a number that matches that for previously defined columns.