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?

 

[rosemaryl]

Dear Sathipatla,

If you are using ODBC, go into ODBC Administrator, select the System DSN, and then click configure.

Under the advanced tab, do you have the Return Results from Procedure Checked? If not, do so and then try again.

Hope this helps,

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[sathipatla]

I am using Oracle native driver. This report is within a package. I am able to access other stored procedures contained in other packages fine. We use public synonyms for the packages.

 

[sathipatla]

One more thing is I am able to create the report based on the stored procedure if I log in as the owner. Crystal is weird sometimes.