Simple little bit of code that works for me in Oracle SQL PLUS but not for my customer. Best I can figure its not waiting for a response
Can anyone help me in figuring out how I make it so the code does pause and waits for that response. Here is the snippet of code. There is a whole bunch of create tables ahead of this but this is where we seem to have an error.
PROMPT Did the Startup scripts complete successfully (without errors)?
ACCEPT cmt_rlbk PROMPT "If yes, Enter COMMIT. Otherwise, enter ROLLBACK (no semicolon): "