When trying to create a layer through the GIS Layer Tool, the following error message appears:
Unexpected error occurs
ORA-00900: invalid SQL statement
ORA-06512: at "SDE.SDO_UTIL', line 203
ORA-06512: at "HIGHWAYS.NM3SDE", line 313
You will need to compile the sde package as the SDE USER, on the server where ArcMap is installed e.g.
start C:\ArcGIS\ArcSDE\ora10gexe\lib\sdo_util.sps SDE
start C:\ArcGIS\ArcSDE\ora10gexe\lib\sdo_util.spb SDE
This should compile the schema correctly and will need to be run where ArcSDE is installed.