Skip to Main Content

Programming Languages & Frameworks

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 read SDO_GEOMETRY

limorAug 8 2016 — edited Aug 16 2016

hi,

I will create a webserver to fetch geometries out of my oracle database (11g Locator).

I am using node.js 4.4.7.

My query works fine for types NUMBER and VARCHAR!

But in addition I wanna read out SDO_GEOMETRY but if I try this the following error occurs:

NJS-010: unsupported data type in select list

Does it mean that I am not able to fetch SDO_GEOMETRY types in the current version?

The work around woudl be to transform the geometry in another type to read this out...

There exists a function inside the database "sdo2geojson3d" which converts the sdo_geometry to a json ( inside db = clob type). But I only get this as result:

  [ 1315274,

    Lob {

      _readableState: [Object],

      readable: true,

      domain: null,

      _events: [Object],

      _eventsCount: 2,

      _maxListeners: undefined,

      _writableState: [Object],

      writable: true,

      allowHalfOpen: true,

      iLob: [Object] },

    'BuildingGroundSurface' ],

Is there an easy way to read out sdo_geometries?

Comments

Adding in @"Christian Neumueller-Oracle" ...

Answer

Hi,

Linkedin requires client_secret as POST parameter for the token request. This does not conform to the OAuth2 standard (see https://tools.ietf.org/html/rfc6749#section-4.3.1) and is currently not supported. I filed bug #28199613 for this issue.

Regards,

Christian

Marked as Answer by Mahmoud_Rabie · Sep 27 2020
Mahmoud_Rabie

Carsten and Christian,

Thanks a lot.

Is there any suggested workaround to log in with a LinkedIn Profile and grasp its data?

Hi Mahmoud,

sorry, no workaround right now.

Regards,

Christian

1 - 4

Post Details

Added on Aug 8 2016
3 comments
2,434 views