The sde.sdexmltotext operator gets dropped and does not get recreated if upgrading packages in an Oracle instance in which the operator already exists.
Recreate the operator with the following:In sqlplus as the sde user run:CREATE OR REPLACE OPERATOR "SDE"."SDEXMLTOTEXT" BINDING (BLOB) RETURN CLOB USING "SDE"."ST_GEOM_UTIL"."SDEXML_TO_TEXT_F";There is no need to run this for project instances. Just run as the sde user.