When I get TOAD to create a plan table for me, it creates one where the first
column is STATEMENT_ID of type VARCHAR2(30). The first time I try and do an
explain plan I get the following error:-
ORA-00604: error occurred at recursive SQL level 1
ORA-12899: value to large for column
.”STATEMENT_ID” (actual: 31, maximum:
What I usually do is modify the table myself so the column is VARCHAR2(50). But
really, we shouldn’t be getting this error. Is this an issue with the
database, or with TOAD?
FYI, we’re on Oracle 10.2.0.4, and I’m using TOAD 10.5, although
this has been happening since TOAD 9.7 at the very least.
Principal Systems Engineer
TKC Global, LLC