Re: How to assign a value to a variable

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_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
Received on Wed Oct 22 2003 - 18:51:05 CDT