XPost: comp.database.oracle, comp.databases.oracle.misc   
   From: x@x.com   
      
   Hi Daniel,   
      
   thanks for your answer. Unfortunately as soon as I put this line of code in   
   my procedure the package's status becomes invalid.   
      
   I tried a simple test   
   pName := '%' || '%';   
   and still doesn't work.   
      
   I am using the wildcard because later in my proc I have a select and I use a   
   LIKE.   
      
   Thanks,   
   Florian   
      
   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)