Oracle DB Error ORA-06566 invalid number of rows specified

The following is the cause of this error message:

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.

Action you can take to resolve this issue: Specify a number that matches that for previously defined columns.

Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory

Related