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 |
ORA-14018: partition bound list contains too few elements
DRG-11854: No File Name Found Or File Not Accessible
TNS-00117: Internal error- No data passed through pump
ORA-31504: cannot alter or drop predefined change source
NID-00125: Database should have no disabled datafiles
ORA-38959: Failed to update block 0 to new version 10 format
ORA-16179: incremental changes to "string" not allowed with SPFILE
NNL-00289: Scheduled cache flush to occur in string
NCR-04018: NCRR: Unable to create the TNS address list
ORA-03277: invalid SIZE specified
ORA-00340: IO error processing online log string of thread string
ORA-09370: Windows 3.1 Two-Task driver ORACLE task timed out