pscbo_stats v2 - error while implementing
SQL> EXEC pscbo_stats.quick_config;
BEGIN pscbo_stats.quick_config; END;
*
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected NUMBER got LONG
ORA-06512: at "SYSADM.PSCBO_STATS", line 1263
ORA-06512: at line 1
It may be due to the mismatch in the field data type in PSDDLMODEL and pscbo_psddlmodel_history shown below. Anybody get similar errors?
desc PSDDLMODEL
Name Null Type
--------------- -------- ----------
STATEMENT_TYPE NOT NULL NUMBER(38)
PLATFORMID NOT NULL NUMBER(38)
SIZING_SET NOT NULL NUMBER(38)
PARMCOUNT NOT NULL NUMBER(38)
MODEL_STATEMENT NOT NULL LONG()