I called a stored procedure with Ref cursor through a crystal report. that worked fine.

Now I have a different situation like, I woule like pass 2 pamameters for my procedure and expecting 7 fields as output from my procedure. All the fields data get through cursor logic in side the procedure.

 

my code structure:

Procedure test ( p1 in varchar2, p2 in date, p3 out varchar2.....p7 out number)

...

begin

for I in ( -- get first set up data for the out parameters p3,p4)

loop

     for j in ( get result for out fileds p5 ,p6 based on the above result set)

     loop

             -- get result for p7

     end loop

end loop

end;

/