When I run dbms_stats either in sqlplus or through the scheduler I get the following message
BEGIN
DBMS_STATS.GATHER_TABLE_STATS('schema_name',table_name',DEGREE => 24);
END;
Error message :
ORA-29900: operator binding does not exist
ORA-06540: PL/SQL: compilation error
ORA-06553: PLS-907: cannot load library unit SYS.XQSEQUENCEFROMXMLTYPE (referenced by SYS.XQSEQUENCE)
ORA-06512: at "SYS.DBMS_STATS", line 34634
ORA-06512: at line 2