how to use select clause in assignment

I am writting a procedure, i am using a table: part(empno,...,partid,..). I already know the partid, and I need to know empno so I can use it to invoke another procedure--like empb(myid). part of the code like:
 myid =

       (select empno
        from part
        where partid = part_id;);

         the following:
         ( - + case mod new not null others <an identifier>


         <a double-quoted delimited-identifier> <a bind variable> avg


         count current exists max min prior sql stddev sum variance
         execute forall merge time timestamp interval date


         <a string literal with character set specification>


         <a number> <a single-quoted SQL string> pipe

17/39 PLS-00103: Encountered the symbol ")" what should I do? Thanks for help! Received on Sat Nov 22 2003 - 04:28:21 CET