Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


SQL-02154: Invalid or unset data type for host variable in
ANSI Dynamic



SQL-02154: Invalid or unset data type for host variable in ANSI Dynamic..

Answer / guest

Cause: An ANSI Dynamic SET statement with item name DATA was
encountered with out a valid TYPE having been previously set
and option mode=ansi was used

Action: With mode=ansi, you must set the TYPE before setting
the DATA. Issue a SET statement with correct item TYPE or,
for output issue a DESCRBE to set the item type. Or use
mode=oracle which allows the type to default to the type of
the bind/define host 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-02279: duplicate or conflicting MINVALUE/NOMINVALUE specifications

1 Answers  


RMAN-10020: error initializing Recovery Manager execution layer

1 Answers  


ORA-16618: response document of size "string" bytes is too large

1 Answers  


ORA-36902: (XSAGDNGL43) In AGGMAP workspace object, the MODEL workspace object is not a model over a base dimension of the AGGMAP.

1 Answers  


ORA-00116: SERVICE_NAMES name is too long

1 Answers  






ORA-08456: no sign in picture mask but SIGN clause in mask options

1 Answers  


ORA-30081: invalid data type for datetime/interval arithmetic

1 Answers  


RMAN-08010: channel string: specifying datafile(s) in backupset

1 Answers  


NZE-28776: Output buffer supplied is too small.

1 Answers  


ORA-13827: null or zero length attribute specified in SQL profile collection

1 Answers  


ORA-25153: Temporary Tablespace is Empty

1 Answers  


ORA-07503: scgcmn: $setimr unexpected return

1 Answers  






Categories