When I click the explain plan button I get the error below. This is for Oracle 19.10 on Oracle Linux 7.8 x64. Please see the attached.
[Error] Explain Plan (27: 43): ORA-00604: error occurred at recursive SQL level 1
ORA-12899: value too large for column "SYSTEM"."TOAD_PLAN_TABLE"."OBJECT_NAME" (actual: 33, maximum: 30)
I dropped the table and recreated and now all is working. Please ignore.
Hi Ed,
Just modify the TOAD_PLAN_TABLE.OBJECT_NAME and OBJECT_OWNER columns so they have a size of 128. I have verified that our source should create it that way if the database supports it, so I guess either an old version of Toad created that table, or the database was upgraded after the table was created.
-John
Looks like this was as you said just old. Thank you
