Re: Passing the "&" in PL/SQL

David,

  When you use '&' in your variables in stored procedures, it would   perfectly work fine. I guess, you are trying to test this stored   procedure in sql*plus. By default, sql*plus assumes the "&"   character to be be something to be prompted. You can overcome this   by using 'SET DEFINE OFF' in your sqlplus session.

  This should solve your problem. If u are still not convinced,   pl. let me know...

Regards
Rajagopal Venkataramany

On Fri, 21 Jul 2000 09:28:51 -0800, ORACLE-L_at_fatcity.com wrote:

> 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).

Regards
Rajagopal Venkataramany