In this post, you’ll learn more about the Oracle ErrorORA-06562: type of out argument must match type of column or bind variable with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-06562: type of out argument must match type of column or bind variable
Reason for the Error ORA-06562: type of out argument must match type of column or bind variable
Attempting 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.
How to fix the Error ORA-06562: type of out argument must match type of column or bind variable ?
You can fix this error in Oracle by following the below steps
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.