I am trying to connect to the Oracle DB using Oracle Client, but always end up with this error. The connection tests successful but fails to pull up the tables or views. However, with the same user, I am able to log in to TOAD and see the tables. So definitely not an access issue but then where does it fail..?
I am on SAP BI 4.1 SP7
Request your views on this, if you have got a solution to this earlier.