Error ORA-00932: inconsistent datatypes
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
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
0