Datatype not supported

[vardhan354]

Hi Gurus,

Today I encountered a unusual error while running a job.Both my source and target databases are oracle.I could see the data in TOAD/PL SQL developer.But when I tried to view the data from datastage Oracle plug-in, it throwed the following error.
" Oracle datatype not presently supported "

The table has following datatypes,

Name , Type

MODULE_NAME, VARCHAR2(40)
ROWS_PROCESSED,NUMBER
CUSTOM_MESSAGE , VARCHAR2(1000)
LOGIN_CREATED_BY,VARCHAR2(30)
START_TIME, NOT NULL TIMESTAMP(6)
END_TIME, TIMESTAMP(6)

I got similar kind of error from another table also.Could you please let me know how can I fix this problem.



Thanks,

VG

[chulett]

OCI does not (yet) natively support TIMESTAMP. Treat is as a varchar in your job.