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-22975: cannot create a PRIMARY KEY-based REF to this object view

1 Answers  


ORA-32845: Messaging Gateway agent is already running

1 Answers  


DRG-10102: mandatory argument missing: string

1 Answers  


RMAN-08038: channel string: starting piece string at string

1 Answers  


QSM-00519: Summary Advisor is not installed. Please execute INITQSMA.SQL.

1 Answers  






ORA-19604: conversation file naming phase is over

1 Answers  


ORA-02296: cannot enable (string.string) - null values found

1 Answers  


SQL*Loader-00942: partition string not part of table string

1 Answers  


PLS-00368: in RAISE statement, 'string' must be an exception name

1 Answers  


ORA-09275: CONNECT INTERNAL is not a valid DBA connection

1 Answers  


ORA-32511: cannot create watchpoint in memory needed by watchpointing code

1 Answers  


ORA-12401: invalid label string: string

1 Answers  


Categories