From: mcstockspamplug@spamdamenquery.com   
      
   look in the first chapter of the PL/SQL Users Guide under 'Assigning Values   
   to Variables''   
      
   you need to user the SELECT INTO syntax   
      
   -- mcs   
      
   "joy"  wrote in message   
   news:357eb048.0311211928.6d86416e@posting.google.com...   
   | 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;);   
   | and I started the procedure, it gave me:   
   | 15/16    PLS-00103: Encountered the symbol "SELECT" when expecting one   
   | of   
   |          the following:   
   |          ( - + case mod new not null others    
   |            avg   
   |          count current exists max min prior sql stddev sum variance   
   |          execute forall merge time timestamp interval date   
   |             
   |            pipe   
   |   
   | 17/39    PLS-00103: Encountered the symbol ")"   
   | what should I do? Thanks for help!   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)