Hi Art:
Is SET SCAN OFF any different from SET DEFINE OFF?

-Dilip

[b][font=Arial, Helvetica, sans-serif][i]DEF[[INE]]{[/i]&[i]&#124[i]c[/i]&#124[/i]ON[i]&#124OFF}[/i][/font][/b]

[list]
[list]

Sets the character used to prefix substitution variables to [i]c[/i]. ON or OFF controls whether SQL*Plus will scan commands for substitution variables and replace them with their values. ON changes the value of [i]c[/i] back to the default[i] '[/i]&'[i],[/i] not the most recently used character. The setting of DEFINE to OFF overrides the setting of the SCAN variable. For more information on the SCAN variable, see the [url="http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a82950/apf.htm#623418"]SET SCAN[/url] command in [url="http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a82950/apf.htm#623304"]Appendix F[/url].[/list][/list]