Try : set def ^
(for example) in the beginning of your package.
David Barbour wrote:
>
> 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 Mon Jul 24 2000 - 02:17:58 CDT
