Error on import Oracle Table definitions

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
jinm
Premium Member
Premium Member
Posts: 47
Joined: Tue Feb 24, 2004 1:59 am

Error on import Oracle Table definitions

Post by jinm »

Hi
When trying to import Table definition using Import -> Table Definitions -> Plug-in meta Data definitons -> OraOCI
AND
connecting to Oracle10gr2 database, the column length are not imported.
On other Oracle versions, column length is imported.
OS: Win2K3
DS: 8.0.1
Ora: Local client has been both Oracle9.0.1.2 and 10gr2 client

Anybody seen anything like that??
Rgds Jan
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

I think that this is a known V8 bug.
jinm
Premium Member
Premium Member
Posts: 47
Joined: Tue Feb 24, 2004 1:59 am

Post by jinm »

ArndW wrote:I think that this is a known V8 bug. ...
Another one to the collection :( :(

Well work around (for those who may find it usefull) is so far to use Microsoft ODBC for Oracle og IBM ODBC for Oracle whenimporting metadata, and use the plugin in the job.

Thanks for the reply
Post Reply