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

NNL-00873: Fastest update processing time: string

1 Answers  


SQL*Loader-00286: ROWS parameter is not supported when loading an IOT.

1 Answers  


ORA-29253: Invalid count argument passed to procedure dbms_sql.define_array

1 Answers  


TNS-00525: Insufficient privilege for operation

1 Answers  


ORA-13412: invalid scale parameter

1 Answers  






LPX-00272: FTP server unavailable: ~s

1 Answers  


ORA-24315: illegal attribute type

1 Answers  


ORA-07236: slemop: open error.

1 Answers  


ORA-25426: remote instance does not support shared dblinks

1 Answers  


EXP-00062: invalid source statements for an object type

1 Answers  


ORA-02817: Read failed

1 Answers  


PCC-02041: CMD-LINE: Option does not exist:

1 Answers  


Categories