A cancel operation stops the current processing and prompts for the next command. The Interrupt The SQL Statement button on the Interactive SQL toolbar cancels a command.

If a command file was being processed, you are prompted for an action to take (Stop Command File, Continue, or Exit Interactive SQL). These actions can be controlled with the Interactive SQL on_error option. See on_error option [Interactive SQL].