XPost: comp.database.oracle, comp.databases.oracle.misc   
   From: x@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.   
      
      
      
   Daniel Morgan wrote:   
      
   > Florian Marinoiu wrote:   
   >   
   > >Hi,   
   > >   
   > >I have the following MS-SQL Server statement that I want to convert to   
   > >ORACLE 8.1   
   > >SET @pPhone = '%' + @pPhone + '%'   
   > >   
   > >In ORACLE I tried   
   > >SELECT '%' || pPhone || '%' into pPhone from dual;   
   > >   
   > >Where pPhone is a parameter that is passed to the procedure.   
   > >   
   > >How could I do it?   
   > >   
   > >Is it a set in ORACLE?   
   > >   
   > >Thanks,   
   > >Florian   
   > >   
   > >   
   > >   
   > It would be helpful to know what you expect as the result since '%' is a   
   > wildcard in Oracle.   
   >   
   > But to accomplish what you appear to want ...   
   >   
   > pPhone := '%' || pPhone || '%';   
   >   
   > And please do not cross-post. One, appropriate, group is enough.   
   >   
   > --   
   > Daniel Morgan   
   > http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp   
   > http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp   
   > damorgan@x.washington.edu   
   > (replace 'x' with a 'u' to reply)   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)