Spatial (MOSC)

MOSC Banner

Error ORA-00932: inconsistent datatypes

edited Mar 14, 2012 12:10AM in Spatial (MOSC) 6 comments
Hi,
I have a problem with the address geocoding.

The function SDO_GCDR.GEOCODE_ADDR fails with ORA 932 error, with one of our addresses.
This is an example:

declare
  addr sdo_Geo_addr;
  addr_Res sdo_Geo_addr;
begin
    addr := sdo_geo_addr() ;
    addr.municipality := 'Vecchiano';
    addr.settlement := 'Vecchiano' ;
    addr.postalcode := '56019' ;
    addr.country := 'IT' ;
    addr.StreetName := 'Strada Provinciale di Vecchiano' ;
    addr.housenumber := '' ;
    addr.matchmode := 'default' ;

      SELECT SDO_GCDR.GEOCODE_ADDR('GEO',
                                    addr)
        into addr_res
        FROM dual;
       
end;

ORA-00932: inconsistent datatypes: previsto an OUT argument at position 3 that is an instance of a user defined Java class convertible to an Oracle type, ottenuto an object that could not be converted

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center