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 |
NNC-00423: invalid data item syntax code string
ORA-19023: The first argument to UPDATEXML operator has to be an XMLTYPE
QSM-01075: materialized view, string, does not support aggregate function, string
RMAN-06134: host command complete
DRG-12606: error encountered while parsing COLUMNS list
SQL*Loader-00283: file processing string "string" ignored for INFILE *
PCC-02432: Cannot open an external LOB (BFILE) in READ WRITE mode
ORA-27037: unable to obtain file status
TNS-03503: Could not initialize NL
ORA-04089: cannot create triggers on objects owned by SYS
ORA-13152: invalid HHCODE type
ORA-38766: cannot flashback data file string; file resized smaller