Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> DEREF Help

DEREF Help

From: <saks1000_at_my-deja.com>
Date: Wed, 30 Jun 1999 01:26:48 GMT
Message-ID: <7lbrof$vp$1@nnrp1.deja.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US