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-16791: Unable to check the existence of the standby redo logs

1 Answers  


RMAN-06598: conversion between platforms 'string' and 'string' is not needed

1 Answers  


RMAN-08131: channel string: specifying datafile copies to recover

1 Answers  


NNC-00422: invalid data type name "string"

1 Answers  


DRG-50601: fatal error

1 Answers  






TNS-12630: Native service operation not supported

1 Answers  


O2F-00341: An error occurred for which no message is available

1 Answers  


SQL-02122: Invalid OPEN or PREPARE for this database connection

1 Answers  


ORA-01980: error during OS ROLE initialization

1 Answers  


ORA-28003: password verification for the specified password failed

1 Answers  


IMG-00809: usage of IMGSimilar is incorrect

1 Answers  


ORA-30202: NULL pointer to OCIMsgh was passed to OCIMsg function

1 Answers  


Categories