Revert scan state when prompting for variable values
- by Dave Jarvis
How do you detect the current SCAN state and revert it after changing it?
An exerpt from the script in question:
SET SCAN OFF
SET ECHO ON
SET SQLBLANKLINES ON
SET SCAN ON
UPDATE TABLE_NAME SET CREATED_BY = &&created_by;
SET SCAN OFF
The problem is that if the script doesn't have the first line (SET SCAN OFF), then the code to prompt…
