Now I meet a problem, ask in the group of the great god, and I set up a current dblink query two oracle database data, which contains a special type of SDO_ORDINATE_ARRAY_STR, query always tip: when you are not allowed to execute a user-defined type column remote operation, but if remove SDO_ORDINATE_ARRAY_STR the data type, you can query, could you tell me which eldest brother know what is the problem?

CodePudding user response:

GIS dongdong, this not too clear, SDO_ORDINATE_ARRAY_STR should be a custom types, estimated to use Oracle Spatia can normal visit,

Never used, please use the answer

CodePudding user response:

Special type of data table,
You create tables as then look line not line,
Look at this: https://blog.csdn.net/tan1012194073/article/details/67635107

CodePudding user response:

Use dblink query there is a lot of restrictions,
By this time oracle internal requirements, we can only follow the rules,
Removed without this type, or to find a way to through clob, type indirect access to XML