In version 9.0.1.8 Toad saves historical, named and personal sql as an XML file - savedsql.xml. Problem is if you execute sql statement creating xml syntax it will break the file. The xml tags in the saved sql statement will then be read as part of the xml tags of the savedsql.xml file causing the syntax to be corrupted. Since Toad is unable to properly read the xml file, it will not show any saved,named or personal sql anymore, although it will still write to the file toad is unable to read it back.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center