I’m working on a tedious project that is requiring me to modify the data in a table after looking up data from another field. In the process, I’m copying text to do my research and then I’m finding the numeric key which I’m pasting into my original grid. Occasionally, I will not actually get the number into the clipboard and so I end up pasting the string into a numeric field in the grid. And, of course, by reflex hitting [Enter] before I look. When I do, I immediately get a string of error messages from Toad giving me an OCI-22060 error, which is correct, but apparently Toad is attempting to do something behind the scenes, over and over and over and over, because I keep clearing the messages and they keep returning. I’m guessing if I was to click ok enough times the messages would eventually stop, but I have seriously clicked on the messages to clear them at least 50 times before giving up in the past and now I just have to kill Toad in order to be able to get past it.
If there was a way for the error message to be displayed and then whatever it is trying to do next to stop so I can correct the problem and continue, that would be ever so much nicer.
I have only ever encountered this while editing in a Desc window, in case it helps for you to know that.
Digital Products & Strategies, Cru | Data Sciences & Analytics