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

ORA-30493: The percentile value should be a number between 0 and 1.

1 Answers  


ORA-22275: invalid LOB locator specified

1 Answers  


LPX-00317: undefined decimal-format "~S"

1 Answers  


LSX-00333: literal "~S" is not valid with respect to the pattern

1 Answers  


ORA-14321: cannot add/drop values to DEFAULT partition

1 Answers  






ORA-28538: result set not found

1 Answers  


ORA-25301: cannot specify recipient list during enqueue

1 Answers  


ORA-24192: the property name cannot be null

1 Answers  


ORA-30574: Cannot create rollback segment in tablespace with AUTO segment space management

2 Answers  


ORA-01182: cannot create database file string - file is in use or recovery

1 Answers  


DRG-50922: PL/SQL execution failed for string

1 Answers  


ORA-31643: unable to close dump file "string"

1 Answers  


Categories