We are using Enterprise Server 4.1.1 with Oracle
Intelligent adapter. We
have configured INSERT operation with a date field.
The INSERT operation
takes brokerDate data type by default. I cannot change
the data type of
this INSERT field. When the operation is executed, it
does not give any
error, but when I execute ‘select orderdate,
from orders’ in SQLPlus, I see following output.
Note that the day, month, year all are coming as 00
values. Why is it? Any
Answers ASAP is appreciated.