Re: Newbie - '&' in PL/SQL [message #370620] |
Tue, 11 January 2000 06:42 |
Paul
Messages: 164 Registered: April 1999
|
Senior Member |
|
|
Hi,
You can redefine the substitution parameter character like this:
SET DEFINE ~
I've used the tilde here, but you can use any character you are sure will not appear in any of the data you need to enter.
Hope this helps,
Paul
|
|
|
Re: Newbie - '&' in PL/SQL [message #370624 is a reply to message #370620] |
Tue, 11 January 2000 09:37 |
ConUladh
Messages: 2 Registered: January 2000
|
Junior Member |
|
|
Thanks, I already have that and it deals with the hard-coded &s just fine, the parameters are inputted via a unix script, say it's ~~1 that's equal to 'A&B', I can get the unix script to recoginise the & alright and I have 'set define ~' before my declare section in my PL/SQL, but when I then set a variable equal to '~~1', I end up with something like 'A|exit0' rather than 'A&B'
|
|
|
|