oracle ora-22804,oracle ora-22804在对象表或用户定义的类型列上不允许执行远程操作...

满意答案

lisa6182

2014.12.22

采纳率：43%    等级：9

已帮助：370人

I've found a work-around for my own problem.

On Metalink, BUG 5929177 describes the same problem.

"SELECTING A SDO_GEOMETRY VIA DBLINK FAILS WITH ORA-22804".

It also explains that the problem only occurs when the table with the spatial data is first in the from clause which I confirmed with my own test data. However, as OWB is constructing the from clause for me I didn''t want to edit directly the PLSQL package. Instead, I used the Joiner Editor, removed then added the group so that it appeared as the last entry in the table, then re-ran the mapping with positive results.

00分享举报