SQL-02153: Invalid character variable for use in a GET/SET
statement



SQL-02153: Invalid character variable for use in a GET/SET statement..

Answer / guest

Cause: An host variable with type other than character,
string or varchar was found as an item name (other than DATA
item) in an ANSI Dynamic GET or SET descriptor statement.

Action: Host variable types for character items (other than
the DATA item) in ANSI dynamic GET or SET descriptor
statements must not be of type LONG or LONG VARCHAR.
Redeclare the variable to be character, string or varchar type

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01645: previous attempt to make read write is half complete

1 Answers  


PLS-00719: only widening of attribute 'string' constraints is allowed

1 Answers  


RMAN-06456: command is obsolete

1 Answers  


ORA-25957: join index where clause cannot contain cycles

1 Answers  


ORA-16549: invalid string

1 Answers  






NCR-04022: NCRR: Invalid procedure descriptor

1 Answers  


DRG-12411: SQL processing error: string

1 Answers  


ORA-38768: resizing datafile string failed

1 Answers  


TNS-12681: Login failed: the SecurID card does not have a pincode yet

1 Answers  


ORA-10583: Can not recovery file string renamed as missing during test recovery

1 Answers  


ORA-26028: index string.string initially in unusable state

0 Answers  


ORA-01549: tablespace not empty, use INCLUDING CONTENTS option

1 Answers  


Categories