Skip to Content
Former Member
Sep 01, 2008 at 02:37 PM

Stored procedure works with TOAD not in Crystal Reports 10



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?