Skip to Main Content
Forums

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!

how to convert postgis geometry to oracle spatial with pg_link

2817821Dec 19 2014 — edited Jan 5 2015

Hi,

I have linked to postgresql 8.4 from oracle database 12c .I haven't any problems to select tables do not contain the geometry column.

For example:

select "objectid" from "parcel"@pg_link;

But When I select the geometry column with pg_link it fails that ORA-28562 and ORA-02063

I do not have opportunity to be able to directly intervene in the PostgreSQL database so I can not convert WKT in postgresql database  so how do I run the following query? I am using Toad.

select "poly" from "parcel"@pg_link

Thanks by advance for any tip.

King Regards.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 2 2015
Added on Dec 19 2014
#database-key-features, #spatial
5 comments
3,720 views