ORA-00942 table or view does not exist

[sathipatla]

I am trying to create a new report based on as Oracle stored procedure and I get the "ORA-00942 table or view does not exist" error (I am able to see the procedure in the data explorer window. When I double click on it to add it to the report it prompts me for the parameters. After 5 minutes it gets back with the error). I am able to run the procedure in SQLplus without any errors.

I am able to create a new report on the same procedure in our development database. When I try to set the location for this report to our production database I again get the ORA-00942 error but I can run the report pointing to the stored procedure in production database when crystal prompts for username/passwd/server.

Any idea why I am getting this error?

 

[lyanch]

The error probably occurs because your user does not have access to one of the tables or views used in the DB. Try running the SP outside of crystal with the crystal users logon and pw and see what happends.

Lisa

From Oracle Docs:

ORA-00942 table or view does not exist

Cause: The table or view entered does not exist, a synonym that is not allowed here was used, or a view was referenced where a table is required. Existing user tables and views can be listed by querying the data dictionary. Certain privileges may be required to access the table. If an application returned this message, the table the application tried to access does not exist in the database, or the application does not have access to it.

Action: Check each of the following:

the spelling of the table or view name.

that a view is not specified where a table is required.

that an existing table or view name exists.

Contact the database administrator if the table needs to be created or if user or application privileges are required to access the table.

Also, if attempting to access a table or view in another schema, make certain the correct schema is referenced and that access to the object is granted.

 

[sathipatla]

Like I said before I am able to run the procedure fine from SQLPlus. This procedure is in a Package. I am able to create reports fine using procedures in other packages. We use public synonyms on the packages.