Datatype not supported
Posted: Wed Jun 07, 2006 4:13 pm
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
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