Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-22804 when using SDO_GEOMETRY.

458941Apr 16 2008 — edited Apr 18 2008
I'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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 16 2008
Added on Apr 16 2008
1 comment
2,852 views