I am trying to post data like below
{
"ORG_ID": "81",
"TRX_DATE": "30-JAN-2024",
"TRX_NUMBER": "240006078",
"ORDER_NUMBER": "4241020007471",
"QUANTITY_ORDERED": "12",
"QUANTITY_INVOICED": "18",
"MAX(SALES_ORDER)": "2240100002376",
"EXTENDED_AMOUNT": " 3,73,600.00",
"sales_detail":[
{
"item_id": 01,
"item_name":"box"
}
]
}
I want to post this data and want to pass it using syrefcursor.
while I am trying the below pl/sql code
DECLARE
l_crusor SYS_REFCURSOR;
Begin
l_cursor := :sales_detail;
apex_json.open_object;
apex_json.write('data',l_cursor);
apex_json.close_object;
end;
getting 555 error, saying datatype is not correct.