Spatial (MOSC)

MOSC Banner

The geometry field inserts data into 12C and uses get_ Wkt() function query, the result is wrong

in Spatial (MOSC) 2 commentsAnswered

Hello, I would like to ask you or the Oracle Technical support team a question:

In oracle12c database, SQL: "insert into tablename" is used

(ID, GEOMETRY)

VALUES

(1,

SDO_ GEOMETRY(2003,

4326,

NULL,

SDO_ ELEM_ INFO_ ARRAY(1, 2003, 1),

SDO_ ORDINATE_ ARRAY(115.48883, 36.59252, 115.4887, 36.59164,115.48883, 36.59252 )));"

Insert spatial geometry data into the spatial table, and then use get_ Wkt() function query, the beginning of the result should be "polygon ((115.48883, 36.59252, 115.4887, 36.59164, 115.48883, 36.59252))", but now the result is ", (115.48883, 36.59252, 115.4887, 36.59164, 115.48883, 36.59252))", the query result is different from the expected, but this problem is not found in 11g version. How did this bug come into being? How to avoid this problem?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center