Skip to main content
Solved

WKB to SDO_Geometry not working correctly with "Multipolygons"

thomastupuivao
Contributor
Forum|alt.badge.img+6

I have a "mapinfo" table that I'm trying to load into a oracle DB with SDO_Geometry. My license doesn't let me create a writer in FME as an Oracle Spatial table. So my workaround is to add the tables as "oracle non-spatial" tables. This works fine for address points but when I run the following SQL;

This updates successfully. The issues is when I check in "Data Inspector" if its saved correctly (for this particular record which is a multipolygon).

 

I get only one of the polygon objects returning;

Best answer by steveatsafe

Hi @thomastupuivao,

Could you try this SQL instead?

 

UPDATE test_postcode SET geoloc = sdo_geometry(wkb,335872);
View original
Did this help you find an answer to your question?

4 replies

steveatsafe
Safer
Forum|alt.badge.img+12
  • steveatsafeSafer
  • Safer
  • Best Answer
  • March 26, 2020

Hi @thomastupuivao,

Could you try this SQL instead?

 

UPDATE test_postcode SET geoloc = sdo_geometry(wkb,335872);
SteveatSafe
thomastupuivao
Contributor
Forum|alt.badge.img+6
steveatsafe wrote:

Hi @thomastupuivao,

Could you try this SQL instead?

 

UPDATE test_postcode SET geoloc = sdo_geometry(wkb,335872);

hi @steveatsafe, that worked!! thanks for that! appreciate it.

steveatsafe
Safer
Forum|alt.badge.img+12
thomastupuivao wrote:

hi @steveatsafe, that worked!! thanks for that! appreciate it.

Awesome!!

SteveatSafe
steveatsafe
Safer
Forum|alt.badge.img+12
thomastupuivao wrote:

hi @steveatsafe, that worked!! thanks for that! appreciate it.

@thomastupuivao,

A couple of other things for your Oracle Database:

Make sure spatial_vector_acceleration=true.

What database release are you running? You might want to see if you are on the latest spatial merge patch.

Also, in case you didn't know - Spatial and Graph is now included in the database at no extra cost (as of Dec 2019).

SteveatSafe

Reply


Helpful Members This Week

Community Stats

31,353
Posts
118,935
Replies
38,972
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.