laptop and a wrench

Bug

The library definition in the Oracle data dictionary must be updated with the correct library path to the file containing st_shapelib. Altering the definition of the library path will invalidate package bodies that refer to it, so the package.

Last Published: August 25, 2014 ArcSDE/Enterprise Geodatabase
Bug ID Number NIM041283
SubmittedJanuary 7, 2009
Last ModifiedApril 2, 2025
Applies toArcSDE/Enterprise Geodatabase
Version found9.3
Operating SystemWindows OS
Operating System Version2003
Version Fixed9.4
StatusFixed

Workaround

To fix the problem, update the library path in SQL*Plus, as the SDE user, by setting the file directory to the location where the st_shapelib.dll resides. SQL> CREATE OR REPLACE LIBRARY st_shapelib 2 AS 'C:\Program Files\ESRI\ArcSDE\ora11gexe\bin\st_shapelib.dll'; 3 /Library created.Creating the library causes dependent objects to become invalid. Oracle best practices recommend all objects should be compiled and valid. To ensure all objects are valid in the SDE schema, execute the following command as the SDE user: EXECUTE sys.utl_recomp.recomp_serial('SDE');PL/SQL procedure successfully completed.Verify all objects are valid. SQL> SELECT object_name FROM user_objects WHERE status = 'INVALID';no rows selected

Steps to Reproduce

Bug ID: NIM041283

Software:

  • ArcSDE/Enterprise Geodatabase

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options