Pretty Urgent on handling OUT parameter in ORACLE procedure to Crystal

[alam]

In one one of FORUM Diane wrote this about using Procedure.., i followed it..,Have a look at it and then i will give u my problem with it,..
_____________________________________________
The way I use Oracle Stored procedures with my reports is by returning the data in a ref cursor.

So first I declare a package to use:

create or replace package spm as
type rctl is ref cursor;
end;

then you create your stored procedure with whatever parameters you want, returning whatever data you want:

CREATE OR REPLACE procedure spm_MyProcedure(
parameter1 in table1.column1%TYPE,
parameter2 in table1.column2%TYPE,
rc1 out spm.rctl) is
begin
open rc1 for
select table1.column3, table1.column4
from table1
where table1.column1 = parameter1 and
table1.column2 = parameter2;
end spm_MyProcedure;
_____________________________________-
Now my problem is whenever i refresh it., its asking for parameter "rc1" along with other parameters ,.., i dont want "rc1" to be shown into my report..
Any help will be appreciated.
Thank You.

 

[CBear]

I have the same problem. If you follow the one and only example I was able to find on Crystal Decisions Web site, you get the same problem.

If you figure it out, let me know.