I have created a stored procedure in oracle to display a resultset through a cursor.But crystal report is showing "invalid cursor".The stored procedure is given below :
create or replace procedure ashis
as
cd recruit.alumini_master.STR_CODES_CODE%type;
cursor c1 is Select STR_CODES_CODE from recruit.alumini_master;
begin
open c1;
loop
fetch c1 into cd;
exit when c1%notfound;
dbms_output.put_line(cd);
end loop;
close c1;
end;
Oracle ver 8.0,Crystal report ver 8.1