I'm not sure how you got that to work before, since the "SRID" of SDO_GEOMETRY and
"SRID" associated with ArcSDE layers refer to completely different things -- Esri SRIDs
have always been sequence-based, while Oracle SRIDs have always been lookup-table
based (Oracle's SRID is a lot closer to Esri's projection engine EPSG coordinate system
factory code, while an Esri SRID refers to the entire coordinate reference, including
coordinate system, precision, and X/Y, Z, and M false origins and offsets).
The Esri SRID associated with a feature dataset can always be determined through looking
at the SRID value in the LAYERS or GEOMETRY_COLUMNS table for the layers in that dataset.
- V