Get ORA-06502 error viewing the Data tab in the Schema Browser
説明
When viewing data in the Schema Browser's Data tab, for some tables, the following error is returned.
ORA-06502: PL/SQL: numeric or value error: character string buffer too small<br />ORA-06512: at line 63<br />ORA-06512: at line 63
対策
WORKAROUND: Select View | Toad Options | Schema Browser | Data Tab and uncheck 'Enable value lookup for foreign key constraints'.
STATUS: This issue is fixed in Toad for Oracle 13.0. This version can be downloaded from the downloads section of our website, which you can access by clicking here.