A Cancel operation stops the current processing and prompts for the next command. The Interrupt button on the Interactive SQL toolbar cancels a command.
If a command file was being processed, or if there is more than one statement in the SQL Statements pane, 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].