Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#18 I am getting Oracle Error while trying to configure

v1.0 (example)
open
nobody
5
2007-07-12
2007-07-12
Anonymous
No

I created an Oracle connector and then configured it. I can then see all tables. Then I select the tables it shows up the SQL query like "select * from s_contact". Then click next and I get "ORA-009942: table or view does not exist".

I have full access to DB. Queries are working fine when from Oracle SQL window. One thing I know tables I want to select are not in my schema they are in different user schema. But I have full access to it. I also tried modifying the query to "select * from siebel.s_contact" which we use when we run queries from Oracle SQL*plus. But that didn't work either.

Please help.

Discussion

  • Logged In: NO

    Please post this bug, if still open, to http://www.apatarforge.org/bug