When debugging a procedure by stepping through the process, the user encounters the error message, "ORA-00911: invalid character". Error did not occur in previous versions of TOAD.
Details:
Debugger was looking at some Oracle API code at the very bottom of the script because the debugger was asked to compile dependencies as well.
WORKAROUND:
1. Go to View | Options
2. In Toad Options window go to Procedure Editor | Debugging and under the Compile Dependencies, set option to 'No' or 'Prompt'.
3. Close and restart Toad and try debugging the script again.
NOTE: If set to 'Prompt', When debugging your procedure, choose NO when asked to compile the referenced objects.
STATUS:
This issue is fixed in TOAD 8.6.0.38. The latest version of Toad can be downloaded at http://support.quest.com/SUPPORT/index?page=downloads
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy