ORA-06562: type of out argument must match type of column or
bind variable



ORA-06562: type of out argument must match type of column or bind variable..

Answer / guest

Cause: 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.

Action: 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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00633: RETURN statement in a pipelined function cannot contain an expression

1 Answers  


ORA-25018: conflicting trigger string already exists

1 Answers  


RMAN-08599: channel string: throttle time: string

1 Answers  


ORA-15019: discovered duplicate path 'string' for 'string'

1 Answers  


ORA-00019: maximum number of session licenses exceeded

1 Answers  






NID-00120: Database should be mounted exclusively

1 Answers  


EXP-00086: Primary key REFs in table "string"may not be valid on import

1 Answers  


KUP-04058: unrecoverable error occurred, operation aborted.

1 Answers  


QSM-00770: the specified workload string is already referenced by task string

1 Answers  


ORA-12715: invalid character set specified

1 Answers  


RMAN-07513: List of Files Which Where Not Cataloged

1 Answers  


DRG-10846: order by columns must be all ascending or all descending

1 Answers  


Categories