From: avah@isd.dp.ua   
      
   Floriane Marinou wrote:   
      
   .......   
      
   > procedure STTESTSELECT (pPhone IN VARCHAR2 default null,   
   >                               p_rc out curTestSelect)   
   >   
   > IS   
   >   
      
   -- here you need to declare your local vars   
      
   pName VARCHAR2(100);     -- place appropriate length instead of "100"   
      
   > BEGIN   
   >   
   >   
   > --  pName := '%' || pName || '%';   
   >   
   >   OPEN p_rc FOR   
   >       SELECT * FROM DUAL;   
   >   
   > exception   
   > when others then   
   >   raise;   
   > END;   
   >   
   > end TEST_PCKG;   
   >   
   > As you can see I put the incriminated line in comments. If it stays like   
   > this my package is valid if I uncomment it becomes invalid.   
      
   As I can see, you should look at compiler error messages more closely :)   
   AFAIU in your case it looked like:   
   PLS-00201: identifier 'PNAME' must be declared   
      
   I think this gives enough information to understand what's the problem.   
      
      
   --   
   WBR,   
   Andrey Vakhnin   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)