Menu ▾ ▴

#18 I am getting Oracle Error while trying to configure

v1.0 (example)
open
nobody
Interface (example) (6)
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

  • Nobody/Anonymous

    Nobody/Anonymous - 2007-07-12

    Oracle Connector error

     
    Oracle connector error.zip

  • Nobody/Anonymous

    Nobody/Anonymous - 2007-09-24

    Logged In: NO

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

     

Log in to post a comment.

MongoDB Logo MongoDB