| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> DEREF Help
Does anybody see a problem with this code? I get a
50/9 PLS-00306: wrong number or types of arguments in call to 'DEREF' error. The argument for deref however is a REF!
MEMBER PROCEDURE print_faculty IS
fac_array persons_array;
ref_p REF person;
p person;
BEGIN
fac_array := SELF.get_faculty();
dbms_output.put_line(' ' || p.LastName);
FOR i in 1.. fac_array.COUNT loop
ref_p := fac_array(i);
p := deref(ref_p);
dbms_output.put(p.Pid);
dbms_output.put(' ' || p.FirstName);
dbms_output.put_line(' ' || p.LastName);
END LOOP;
END;
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Tue Jun 29 1999 - 20:26:48 CDT
![]() |
![]() |