ORA-22804 when using SDO_GEOMETRY.
458941Apr 16 2008 — edited Apr 18 2008I'm doing a simple test to load spatial data into my target table and get an ORA-22804 error.
I've pulled the SQL out of the generated PLSQL package and have managed to reduce the problem to a simple select.
Here are three examples, the first of which comes from the package and fails whilst the second two work although they do similar things.
-- This gives an ORA-22804
SELECT UT.POLYGON
FROM ALMACEN.UTGEOMDER@BDMANTE@ALMACENMANTE UT, ALMACEN.RELUTNOMDOC@BDMANTE@ALMACENMANTE R
WHERE R.IDUT = UT.IDUT
-- This works
SELECT UT.POLYGON
FROM ALMACEN.UTGEOMDER@BDMANTE@ALMACENMANTE UT
-- This works
SELECT UT.IDUT
FROM ALMACEN.UTGEOMDER@BDMANTE@ALMACENMANTE UT, ALMACEN.RELUTNOMDOC@BDMANTE@ALMACENMANTE R
WHERE R.IDUT = UT.IDUT
The only difference between the first and the last example is that I'm requesting a SDO_GEOMETRY field instead of a NUMBER. The join is the same.
I understand that the problem is related to the combination of DBLINK and SDO_GEOMETRY.
Is there any work-around for OWB?
Maybe telling it not to use dblink.
I'm using the following versions.
OWB Client 11.1.0.6.0
OWB Repository 11.1.0.1.1
The dblinks connect to database version 10.2.0.3.0 64-bit and the data comes from views in a versioned database (OWM).
Regards,
Lew.