stored procedure problems

[tsusnik]

I'm reporting off a stored procedure for the first time and have a few problems although I read all the white papers, FAQs etc.

The sp has one 'in' parameter and one 'in out' (cursor). In the Record Selection Formula I wrote: {?sp_id}={?id}

The first problem is that the Stored Procedure Parameters option in the Database Menu is disabled all the time, so I can't even see what's in it.

Second, when I'm prompted for parameters, all three (even the cursor) are listed, then the result is empty. This is the SQL query (from Show SQL Query):

BEGIN USER.STORED_PROCEDURE(10, :CURSOR_NAME); END;

Thanks for any help.

Regards, Tomaz

 

[tsusnik]

I opened a new report and added the stored procedure and now I can't even add the parameters in record selection (they are not listed).
Any ideas?

Tomaz