error inserting stored procedure

[tsusnik]

When I wish to insert a stored procedure in my report I get the 'error' ORA-00000: normal, successful completion. If I click 'Add' once again I get the error ORA-01001: invalid cursor. I'm working on an Oracle database and the stored procedure does not execute another stored procedure. The stored procedure executes successfully in SQL Plus.

Thanks for any ideas!

Tomaz

 

[jaburke]

Did you ever figure this out? I am having the same problem!

 

[tsusnik]

I figured this out a long time ago, so I don't even remember what caused this error. Please check this:

1. Is your first parameter in the procedure 'in out'?

2. If you use odbc, did you check 'Procedure returns results'?

3. Does the odbc connection use cror815.dll?

Regards, Tomaz