Works in SQL*Plus but not in PL/SQL

I have searched the group and found some similar things but I haven't solved my problem yet. Any help would be appreciated.

This update statement works in SQL*Plus, but it doesn't work when I try to compile it in a PL/SQL Package.

   update rh_1 rp
   set gid =

     nvl((select min(rp2.gid)
          from rh_1 rp1, rh_1 rp2
	  where rp.gid = rp1.gid
	  and rp1.dl = rp2.dl
	 ),gid);

I get PLS-00103: Encountered the symbol "SELECT" when expecting one of the following: ( - + ....

Thanks,
Bill Hoernke
GartonWorks, Inc. Received on Wed Jun 05 2002 - 16:35:20 CDT