Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to assign a value to a variable

Re: How to assign a value to a variable

From: Florian Marinoiu <x_at_x.com>
Date: Wed, 22 Oct 2003 19:28:38 -0400
Message-ID: <3F9712A6.6F107098@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_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
Received on Wed Oct 22 2003 - 18:28:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US