Getting errors"ORA-22835" and "ORA-06564" when selecting the Script tab in the Schema Browser fo (4266059)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Getting errors"ORA-22835" and "ORA-06564" when selecting the Script tab in the Schema Browser fo
Description

Getting errors"ORA-22835" and "ORA-06564" when selecting the Script tab in the Schema Browser for an external table with a non sys user
The full error message is:
"Field type should be CLOB, BLOB or File
ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 13325, maximum: 4000)"
Followed by

"ORA-06564: object EXTERNAL_TABLES_DIR does not exist"
Resolution

WORKAROUND:
None
STATUS:
Waiting for fix in a future version of Toad for Oracle.
Defect ID

CR76417
Additional Information

Another similar issue: This error can be generated on its own by clicking on the Data tab ONLY

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title