Re: RE: Passing the "&" in PL/SQL

From: Nechama Glasrot <Nglasrot_at_co.palm-beach.fl.us>
Date: Fri, 21 Jul 2000 15:12:59 -0400
Message-Id: <10565.112674@fatcity.com>

you need to add something else

select '\& abc' escape '\'
from whatever;

will return &a

thank you ...

Nechama Glasrot
DBA
COC Automation Services - Palm Beach County nglasrot_at_co.palm-beach.fl.us
561-355-3467

>>> Steven Monaghan <Steve.Monaghan_at_wcom.com> 07/21 3:06 PM >>> in your script...

before your PL/SQL block

set escape \

then replace & with \& and it should work.

Steve Monaghan
WorldCom
Long Island, NY, USA

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of David
> Barbour
> Sent: Friday, July 21, 2000 1:29 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Passing the "&" in PL/SQL

>=20
>=20

> I'm resending this because it hasn't shown up on my e-mail yet.

>=20

> David A. Barbour
> Oracle DBA - ConnectSouth
> 512-681-9438
> dbarbour_at_connectsouth.com=20

>=20
>=20

> -----Original Message-----
> Sent: Thursday, July 20, 2000 6:04 PM
> To: 'ORACLE-L_at_fatcity.com'=20

>=20
>=20

> Hello good people (a little flattery never hurts!) -

>=20

> Has anybody found a way to pass a variable in a stored procedure that
> contains a " & " symbol without having to parse the data selected, =
search
> for the & , and actually build your variable?

>=20

> I'm selecting business names into a variable. If the name is=20
> something like
> Father & Sons, I bomb out on calling the next screen. I've tried=20
> all kinds
> of combinations of single quotes and double quotes along with some
> suggestions of using the ! and @ signs. The suggestions get=20
> weirder as the
> day grows older. The day isn't the only thing growing older either.

>=20

> Any help or suggestions would be appreciated.

>=20

> David A. Barbour
> Oracle DBA - ConnectSouth
> 512-681-9438
> dbarbour_at_connectsouth.com=20
> --=20
> Author: David Barbour
> INET: DBarbour_at_connectsouth.com=20

>=20


> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing Lists

> --------------------------------------------------------------------

> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>=20
--=20
Author: Steven Monaghan
  INET: Steve.Monaghan_at_wcom.com=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may Received on Fri Jul 21 2000 - 14:12:59 CDT