After upgrading Toad I get an error when trying to run explain plan on anything. I click on the explain plan icon in the editor, and even with a simple select * from dual; SQL statement, i get the following error.
ora-00604: error occurred at recursive SQL level 1
ora-12899: value too large for column apps.plan_table.statemetn_id (actual 33, maximum 30)
or
ora-01401: value too large for column apps.plan_table.statemetn_id
The statement_ID generated by Toad for the explain plan is too long for the default column length of 30. This is a combination of a number and a user name (which is stored as WinUserName= in the Toad.ini file)
SOLUTION 1:
Alter your plan table's Statement_ID column to be bigger then 30. The plan table name can be accessed from View | Toad Options | Oracle | General options screen.
SOLUTION 2:
Alter your Toad.ini file so that the WinUserName= is not as long. Keep in mind that this may possibly affect other Toad features that may use the WinUserName= value.
Keep a back up of Toad.ini to revert back to if necessary.
As for TOAD for Oracle 9.7.2, the new location of the toad.ini is located on the following path:
C:\Documents and Settings\<user name>\Application Data\Quest Software\Toad for Oracle\9.7\User Files
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center