Skip to Content

Oracle12 Ora-942 Table or view does not exist

Hi We are running Crystal Reports for Visual Studio 2010 and are testing with Oracle 12c. We connect to Oracle directly from the Crystal Report, not from Visual Studio. We are connecting with Oracle Client (have tried v.11 and v.12). When trying to generate the report we get an Ora-942 Table or view does not exist. We are calling an Oracle Package which contains procedures. This DOES work successfully when connecting to Oracle 11g, but is NOT working with Oracle 12c. Has anyone experienced or resolved this same issue? Thanks.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Mar 26, 2015 at 09:59 AM

    hi Tony,

    I'm a bit late to see your question, but it still looks unanswered. I think you're possibly seeing the same problem I did. Have a read of this: http://scn.sap.com/thread/3707944

    We were (and are) using Crystal 2008 but we observed the problem in 2013 as well.

    Thanks,

    Stephen.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 12, 2015 at 12:36 PM

    Hi Tony.

    I am not familiar with Crystal Report, but one thing is obvious here. There are structural differences between 11g and 12c. This is the explanation for ORA-00942. Can you please let me know the relevant SQL Statement or object that is missing? So I can give you a much more specific answer.

    Just a remark. Please check if 12c is released for Crystak Report. Generally, Oracle 12c is not yet released by SAP.

    Regards,

    János

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi

      Thank you for your response. Any SQL in a procedure or
      package gives the error. If we do a query we do not get the Ora-942
      error.

      We are able to run the Package/procedures directly on Oracle. It seems that Crystal or the driver

      (crdb_oracle.dllk) does NOT recognize the new structure in Oracle 12c.

      Any query gives the error, for example: select * from dual; will
      give the error.

      Thanks,

      Tony

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.