Showing results for 
Search instead for 
Did you mean: 

Stored procedure works with TOAD not in Crystal Reports 10

Former Member
0 Kudos


I made a stored procedure to fill a table.

When i run it in TOAD it works fine, but in Crystal Reports 10 I get the following error:

Query Engine Error: 'ORA-00942: table or view does not exists

On the line where the stored procedure executes a quey.

I login with the same user in TOAD and in Crystal Reports 10.

And I use the Oracle Server Connection.

For me it's very strange, because the user/server are the same.

Crystal Reports and TOAD are installed local on the same system.

Does anyone know how i can solve this problem?

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

Search Documents and notes on how to create an Oracle Stored Procedure.

Former Member
0 Kudos

Are you referencing another database that Crystal can't see? Also, you can try and copy the SQL to a command object in Crystal to see if it behaves differently there.