The SDO_GCDR package contains the Oracle Spatial geocoding subprograms, which let you geocode unformatted postal addresses.
For a complete description of this package within the context of Oracle Spatial, see SDO_GCDR in Oracle Spatial and Graph Developer's Guide.