Issue passing multiple parameters to a sql sript
When I run my script I am prompted for each parameter every time it comes up in the script. My question is how can I ensure that I am only prompted once for each parameter?
Also the output includes some unnecessary details in the file I spool to, such as:
Enter value for 1: USER1
old 1: select 'grant ' || PRIVILEGE || ' on ' || owner || '.' || TABLE_NAME || ' to ' || &1 || decode(GRANTABLE,'YES',' with grant option;','NO',';') from