Stored procedure works with TOAD not in Crystal Reports 10

[Former Member]

Hi,

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?

[former_member11696]

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

[Former Member]

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.