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-06313: IPA: Shared memory failed to initialise
LCD-00217: failure while processing file parameter [string]
ORA-26010: Column string in table string is NOT NULL and is not being loaded
ORA-32640: FOR LIKE loops are not allowed for multi-byte character types
DRG-11502: read of file failed at line string for file string
ORA-13340: a point geometry has more than one coordinate
ORA-32628: invalid nesting of MODEL cell reference
ORA-04075: invalid trigger action
ORA-10587: Invalid count for ALLOW n CORRUPTION option
ORA-33308: (DBVALID04) SEVERE ERROR: Record number used but not allocated
ORA-07287: sksagdi: unsupported device for log archiving.
ORA-16593: XML conversion failed