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

TNS-12154: TNS:could not resolve the connect identifier specified

1 Answers  


ORA-27076: unable to set limit for open files

1 Answers  


RMAN-12014: multiple records for default channel configuration for string found in catalog

1 Answers  


ORA-01104: number of controlfiles (string) does not equal string

1 Answers  


NNC-00001: maximum number of connections already open

1 Answers  






ORA-02808: Allocation of memory of open files array failed.

1 Answers  


ORA-12232: TNS:No path available to destination

1 Answers  


SQL*Loader-00402: Unable to determine length of column string from specification

1 Answers  


ORA-38958: Source platform string is in different byte order than target platform string

1 Answers  


IMP-00014: option "string" is needed, but not present in database

1 Answers  


SQL*Loader-00281: Warning: ROWS parameter ignored in parallel mode.

1 Answers  


ORA-02063: preceding stringstring from stringstring

1 Answers  


Categories