The sde.sdexmltotext operator gets dropped and does not get recreated if upgrading packages in an Oracle instance in which the operator already exists.
Last Published: August 25, 2014No Product Found
Bug ID Number
NIM058256
Submitted
June 11, 2010
Last Modified
June 5, 2024
Applies to
No Product Found
Version found
10.0 Beta
Version Fixed
N/A
Status
Fixed
The bug has been fixed. See the Version Fixed and Additional Information, if applicable, for more information.
Workaround
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.