Conditional Use of ACCEPT
I would like to use ACCEPT to prompt the user for parameters, if and only if there were no arguments (or too few) passed from a shell script or a START command. Essentially, the SQL*Plus script can run interactively with parameters prompted for or in batch with parameters just expected.
It appears that I cannot place the ACCEPT statement (SQL*Plus) inside of a PL/SQL IF/THEN block so I don't think that I check for arguments at run time and only prompt for input if no arguments were presented.
I would prefer a SQL*Plus solution for portability but an alternative seems to be to do this logic and prompting in a shell script (Windows or DOS .BAT, actually, and maybe this doesn't qualify as shell script) and always pass arguments into the SQL*Plus script.