Page 1 of 1

Problem when importing column defination

Posted: Wed Jun 20, 2007 5:26 am
by opdas
Hi Guys,

I have problem when I try import table defination through Plug-in metadata table defination.
The length for varchar2 and char are not imported.
While there is no problem when we import through ODBC.

Posted: Wed Jun 20, 2007 5:59 am
by ray.wurlod
Do you have Enterprise Edition? If so, import using the Orchestrate orchdbutil utility. There are known issues with OCI, and ODBC must make certain assumptions because of its own protocols.

Posted: Wed Jun 20, 2007 6:43 am
by opdas
Thanks for your response.
No we dont have enterprise edition.
So can we classify this as datastage bug.

Posted: Wed Jun 20, 2007 6:53 am
by ray.wurlod
No, it's actually an Oracle bug. It does not give correct responses to standard function calls such as SQLColumns().