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!

Insert Date in ORDS

Arif2018Dec 7 2020 — edited Dec 8 2020

i am tryting to send post statement using ORDS to one of the table in oracle. there are two fields , one is of type varchar2(12) and the other one is in date format. I am getting the error as bad request or not able to insert the date .What is the syntak for inserting the date data using json format into Oracle.
[code]
{
"opportunity_no": "1",
"date_entered": "01-JAN-2020"
}

[/code]

Added on Dec 7 2020

11 comments

1,490 views