Spatial Type for Oracle: SDE.ST_Is3D returns 0 instead of 1 on geometries with Z values on AIX/Oracle10g and HP Tru64/Oracle9i

The following are two examples that show the results from using the Oracle INSTR function:

In the first example, the geometry does contain the Z dimension and thus the INSTR returns a non-zero value, the offset to the first 'Z' found in the text string.

Code:
SQL> select instr(sde.st_astext(sde.st_geometry('point z (1 1 1)',0)),'Z') from
dual;

INSTR(SDE.ST_ASTEXT(SDE.ST_GEOMETRY('POINTZ(111)',0)),'Z')
----------------------------------------------------------
                                                         7

Code:
SQL> select instr(sde.st_astext(sde.st_geometry('point (1 1)',0)),'Z') from dual
;

INSTR(SDE.ST_ASTEXT(SDE.ST_GEOMETRY('POINT(11)',0)),'Z')
--------------------------------------------------------
                                                       0