For some reason, this one problem report I keep trying to send to the group via e-mail isn’t making it there. So I’m posting from ToadWorld and hoping the others just die out is cyberspace without spamming the group when it finally hit the boards.
First the great news. I’ve been working in the Editor all day (it has now been all day yesterday and all day today with 2 times I had my computer hibernate in between) and it hasn’t crashed at all!!! This is a ginormous improvement over the past few weeks, so, Michael, a million thanks for the fix.
I’m working on a package in the editor that has some complicated dynamic sql building in it. So I’m making a few changes, formatting, compiling, swapping tabs to execute the code, refreshing a Desc window grid that has the SQL I’m building stored in the table, and then switching back to my package to tweak it again and repeat.
As I’ve been working, I’ve found that after several sets of changes to my package, I’ll all of a sudden get a compile error
[Error] PLS-00103 (733: 33): PLS-00103: Encountered the symbol “end-of-file” when expecting one of the following: ( begin case declare end exception exit for goto if loop mod null pragma raise return select update while…
Formatting shows no syntax errors, but the compile fails. If I then save my package file, close it, open it in another tab and compile again, the compile works just fine. So it appears that the problem is in TOAD, not in my code.
I’m not sure if this is sufficient information to give you - let me know what other details you need.