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-12711: this CREATE CONTROLFILE character set is not allowed

1 Answers  


ORA-07647: sszfck: $OPEN failure

1 Answers  


ORA-06775: TLI Driver: error reading break mode

1 Answers  


LSX-00300: group must have name or ref but not both

1 Answers  


TNS-00224: No more connections available

1 Answers  


KUP-04018: partial record at end of file string

1 Answers  


RMAN-06536: BACKED UP ... TIMES option is supported only for archived logs

1 Answers  


ORA-09841: soacon: Name translation failure.

1 Answers  


ORA-22856: cannot add columns to object tables

2 Answers  


ORA-13240: specified dimensionality greater than that of the query mbr

1 Answers  


ORA-02713: osnprd: message receive failure

1 Answers  


ORA-26696: no streams data dictionary for object with number string and version number string from source database string

1 Answers  


Categories