Home » RDBMS Server » Server Administration » Re: Newbie - '&' in PL/SQL
Re: Newbie - '&' in PL/SQL [message #370620] Tue, 11 January 2000 06:42 Go to next message
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 Go to previous messageGo to next message
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'
Re: Newbie - '&' in PL/SQL [message #370629 is a reply to message #370624] Tue, 11 January 2000 18:30 Go to previous message
ConUladh
Messages: 2
Registered: January 2000
Junior Member
It's turned out to be a problem with the unix script, I got around it anyway.
Previous Topic: Blank space insertion into a Database field of VARCHAR2(1)
Next Topic: Saving into two tables
Goto Forum:
  


Current Time: Fri Oct 30 02:45:13 CDT 2020