XPost: comp.database.oracle, comp.databases.oracle.misc   
   From: root@127.0.0.1   
      
   "Florian Marinoiu"  wrote in message   
   news:3F9717E9.9B580851@x.com...   
   > Here is the code for the packages that I use   
   >   
   > CREATE OR REPLACE  PACKAGE "CDMVWEB"."TEST_PCKG"   
   > IS   
   > TYPE curTestSelect is ref cursor;   
   >   
   > procedure STTESTSELECT (pPhone IN VARCHAR2 default null,   
   >                               p_rc out curTestSelect);   
   >   
   >   
   > end   
   > ;   
   >   
   >   
   > And for the Body   
   >   
   >   
   >   
   > CREATE OR REPLACE  PACKAGE BODY "CDMVWEB"."TEST_PCKG"   
   >     AS   
   >   
   > procedure STTESTSELECT (pPhone IN VARCHAR2 default null,   
   >                               p_rc out curTestSelect)   
   >   
   > IS   
   >   
   > 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.   
   Florian,   
      
   I can see a couple of problems.   
      
   First the variable pName doesn't exist so you can't assign it a value.   
      
   If you really meant to use the IN parameter pPhone rather than pName then   
   you will find that Oracle won't allow you to change the value if an IN   
   parameter, only an OUT or IN OUT parameter.   
      
   Paul Dixon   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)