Unable to read oracle data

chulett · Post by **chulett** » Wed Mar 17, 2010 3:58 pm

The other thing I would look at would be to follow the instructions as documented - create a role, assign the grants to the role and then the role to the user. That is not equivalent to direct assignment of grants to a user, btw. See if that 'fixes' things. If not, then I'll jump right in the same 'very odd problem indeed' boat next to Arnd.

surajkumar · Post by **surajkumar** » Wed Mar 17, 2010 8:20 pm

Oracle 11g

Datastage 7.5.2

surajkumar · Post by **surajkumar** » Wed Mar 17, 2010 8:26 pm

i have just hard coded the value NSO_REF .their is no parameter

i have tried what u said,created a test table and tried to access getting same issue

i am using .

Oracle 11g and Datastge 7.5.2

chulett · Post by **chulett** » Wed Mar 17, 2010 10:32 pm

You do know that 11g isn't "officially" supported, yes? Unless I've missed something lately. Regardless, have you raised this issue with your official support provider?

surajkumar · Post by **surajkumar** » Thu Mar 18, 2010 6:26 am

i tried with

Read method=user defined query like "select * from <Table>"

i can able to connect and view data

But not with read method=Table