Re: problem with ampersand

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Fri, 21 May 2004 14:45:58 -0400
Message-ID: <yK2dnVgW2dkk0zPdRVn-sQ@comcast.com>

in SQL*Plus issue:

SET SCAN OFF which turns off variable substitution -- SQL*Plus variables by default begin with '&'

++ mcs

"Ford Desperado" <ford_desperado_at_yahoo.com> wrote in message news:e96bc0d0.0405211013.6f35bb13_at_posting.google.com...
| Hi,
|
| I'm trying to create a function that includes this line:
|
| CHR(13)|| 'Run Type: ' || (CASE SD_RUN_TYPE WHEN 1 THEN 'Manual' WHEN
| 2 THEN 'L&L' ELSE 'Automatic'
|
| when I run the script via either SQL*Plus or TOAD, I get a prompt:
|
| Enter value for l: 1
| old 97: CHR(13)|| 'Run Type: ' || (CASE SD_RUN_TYPE WHEN 1 THEN
| 'Manual' WHEN 2 THEN 'L&L' ELSE 'Automatic' END) ||
| new 97: CHR(13)|| 'Run Type: ' || (CASE SD_RUN_TYPE WHEN 1 THEN
| 'Manual' WHEN 2 THEN 'L1' ELSE 'Automatic' END) ||
|
| which means I'm getting 'L1' instead of the 'L&L' token that I need.
| Although I already have a workaround, I'm quite curious why would that
| happen
|
| TIA
Received on Fri May 21 2004 - 13:45:58 CDT