You'll need to provide more information, including:
- The RDBMS you are using
- The geometry storage format
- The topology class of the features (point/line/polygon)
Note that not everyone on this forum self-identifies as a "geek", so your
greeting might be considered offensive to some. I suggest you stick to
less charged terms when requesting help from folks.
Polygons have at least 3 unique vertices and a centroid -- Which X,Y value are you
trying to extract? Or do you want them all? And what are you planning to do with
it/them once you have it/them?
It might be easier to use ST_PointN to fetch individual points inside PL/SQL
(instead of text processing on a CLOB), which is why I asked what you were
planning to do with them.