Skip to Main Content

ORDS, SODA & JSON in the Database

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

POST Json data with nested object to DB Table using ORDS

Robert SibekMar 16 2019 — edited Mar 20 2019

Hello,

I am currently developing Apex application and need to use ORDS endpoints for data callback.

When I tried to post without nested object, everything was working perfectly. But recently, API provider made some changes and now some information are presented as nested Object.

This is the Json sample configured in the provider's backend.

{

  "device" : "37AB2C",

  "time" : "1552749097",

  "data" : "0d01da0c1600",

  "signal" : "Average",

  "location" : {"lat":49.21706417063655,"lng":16.627916371512473,"radius":9228,"source":2,"status":1},

  "seqnumber": 1714

}

This is the table, to which I am insterting data:

CREATE TABLE "SENSOR_DATA"

   (

"DEVICE" VARCHAR2(8 BYTE) NOT NULL ENABLE,

"TIME" NUMBER(*,0),

"SIGNAL" VARCHAR2(12 BYTE),

"DATA" VARCHAR2(24 BYTE),

"LOCATION" VARCHAR2(20 BYTE),

"SEQNUMBER" VARCHAR2(20 BYTE)

   )

Thank you for any suggestion.

This post has been answered by thatJeffSmith-Oracle on Mar 18 2019
Jump to Answer

Comments

Alex Keh-Oracle
Answer

I filed bug 28130097 for this issue. I'm not sure what the best resolution is here, but it's something the DB server and client dev teams should discuss.

Marked as Answer by LeChuck · Sep 27 2020
LeChuck

Okay, thanks. I will check the bug report every now and then for updates.

Mohammed Al-Masri

This issue got resolved please?

Mohammed

Alex Keh-Oracle

The bug has not been fixed yet.

1 - 4

Post Details

Added on Mar 16 2019
4 comments
1,876 views