I am unable to compile a package. When I hit F5 nothing happens. I have to restart the toad to do that. But after a while it reappears again.
Toad for Oracle Base Subscription (64-bit)
17.1.717.3711
F5 should execute the entire contents of the Editor as Script.
Was going to ask if you assigned F5 to some other function in the Shortcuts menu, but doesn't appear so, since F5 works when you highlight the commented query.
I can't reproduce this, either in Subscription or Perpetual Toad 17.1.
Curious, what happens if you place your editor cursor at the beginning of your script and hit F5? Does script code execute successfully when using Toad Script Runner?
If issue persists, might have to open a Support ticket.
Hi Gary,
I did not assigned F5 to some other function.
It works as soon as the application is launched.
But at some point it stops working and I have to restart it again.
Very curious... any one else encounter this issue?
At any rate, please open a support ticket so Quest can document, and resolve.
Do you have any special, nonprintable characters in your PL/SQL? This was ringing a bell so I searched through my Teams history and found a support case for a similar situation. In that case the user had a string with characters below ASCII #32 (space) which are not printable. You should be able to see them in the Editor when you scroll through the code. In that user's case they had chars like ETX, STX, DEL, BEL, etc.
Here is a snippet showing what I mean. If your code has any of these, it's not going to work.
If this is your case as well, you can use the CHR() function and string concatenation || to build out the same string using regular characters.
Hi,
no I don't have
When it happens next, please use the Save button in the Editor and save the contents to file and email them to me if you can. If you cannot email the exact code you're using, please find a reproducible sample that you can share. Use save instead of copy/paste. michael.staszewski@quest.com
Thanks,
Michael