no data from procedure

From: kerim <mjablons_at_usunto.poczta.fm>
Date: Sat, 28 Sep 2002 17:06:15 +0200
Message-ID: <an4get$la$1_at_news.tpi.pl>

Hi,
I'm trying to create a data block based on a stored procedure using a data block wizard. The declaration of the procedure is

proc ( ref_cur IN out ref_cur_type,

        in_param1 IN varchar2,
        out_param1 in out number,
        out_param2 in out varchar2
         ) is
begin
        open ref_cur for ....;
	out_param1 := 2;
	out_param2 := 'text';	

end;         

and in the wizard I've assigned :parameter.param1 and :parameter.param2 to both return variables. When I execute query, the data from cursor is displayed correctly, but i receive no data in my return parameters.

What do I do wrong? Forms 6.
Thanks in advance. Received on Sat Sep 28 2002 - 17:06:15 CEST