RE: Passing the "&" in PL/SQL

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
>
>
> I'm resending this because it hasn't shown up on my e-mail yet.
>
> David A. Barbour
> Oracle DBA - ConnectSouth
> 512-681-9438
> dbarbour_at_connectsouth.com
>
>
> -----Original Message-----
> Sent: Thursday, July 20, 2000 6:04 PM
> To: 'ORACLE-L_at_fatcity.com'
>
>
> Hello good people (a little flattery never hurts!) -
>
> 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?
>
> I'm selecting business names into a variable. If the name is
> something like
> Father & Sons, I bomb out on calling the next screen. I've tried
> all kinds
> of combinations of single quotes and double quotes along with some
> suggestions of using the ! and @ signs. The suggestions get
> weirder as the
> day grows older. The day isn't the only thing growing older either.
>
> Any help or suggestions would be appreciated.
>
> David A. Barbour
> Oracle DBA - ConnectSouth
> 512-681-9438
> dbarbour_at_connectsouth.com
> --
> Author: David Barbour
> INET: DBarbour_at_connectsouth.com
>
> 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).
Received on Fri Jul 21 2000 - 12:49:35 CDT