Home » Developer & Programmer » Reports & Discoverer » rep-0737 (windows xp , chrome )
icon3.gif  rep-0737 [message #468800] Mon, 02 August 2010 04:19
narama87
Messages: 8
Registered: July 2010
Junior Member
hello everyone ,
this is my package , that i put in program units :
PACKAGE RefCurPack IS 
TYPE EmpCurType IS REF CURSOR RETURN
FETUDIANT%ROWTYPE;
END;


and this is my ref cursor in the data model :
 
function QR_1RefCurDS  return refCurPack.empcurType
is 

	v_empcur refCurpack.empcurtype;
begin

  open v_empcur for ' select * from fetudiant';
  return v_empcur;
end;


but , the ref cursor is not working and the error is :

Rep-0737 : should be a function with return type 'ref cursor'

any ideas ???
Previous Topic: Help (linking report)
Next Topic: Getting the query text from Reports
Goto Forum:
  


Current Time: Wed Apr 24 02:28:02 CDT 2024