After an Insert, Update, Delete statement is performed on table data in SQL Editor and I do not Commit the changes, the updated values do not show in Schema Browser or when I run a query on the same table. I want to be able to preview the changes before I perform a Commit transaction.
RESOLUTION 1:
1) Go to View | Toad Options | Oracle | Transactions
2) Make sure "Execute scripts in Toad session" is checked
3) Please only use either the "Execute as Script" (F5) button or the "Execute Statement" (F9) button in the SQL Editor Window. Do not interchange the usage of the two buttons in checking the result of your Update Statement as these buttons use different Oracle Sessions.
RESOLUTION 2:
1) Select View | Toad Options | Oracle | Transactions
2) Uncheck "Execute queries in threads"
3) Ensure to use "Execute Statement" (F9) button not "Execute as Script" (F5) button . This will provide the ability to view the changes after the Schema Browser window is refreshed. Currently "Execute as script" (F5) is automatically creating a new session, executing in queries unless Toad is told otherwise.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center