Oracle DB Error ORA-06562 type of out argument must match type of column or bind variable

The following is the cause of this error message:

An attempt was made to get the value of a column or a bind variable by calling procedure COLUMN_VALUE or VARIABLE_VALUE of package DBMS_SQL but the type of the given out argument where to place the value is different from the type of the column or bind variable that was previously defined by calling procedure DEFINE_COLUMN (for defining a column) or BIND_VARIABLE (for binding a bind variable) of package DBMS_SQL.

Action you can take to resolve this issue: Pass in an out argument of the correct type when calling procedure COLUMN_VALUE or VARIABLE_VALUE. The right type is the type that was provided when defining the column or binding the bind variable.

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

Related