我正在嘗試在 EBS（12.2.10）的 Rest Service 中傳遞 JSON 陣列，但出現以下錯誤：
“-40491 ORA-40491: JSON_TABLE 的輸入資料型別無效”
我創建了以下型別：
CREATE OR REPLACE EDITIONABLE TYPE XRCL_CB_INBOUND_TALLY_OBJ AS OBJECT
(TRANSACTION_DATE VARCHAR2(30),
TRANSACTION_TYPE VARCHAR2(5),
ORGANIZATION_ID VARCHAR2(5),
DOCUMENT_ID VARCHAR2(25),
DOCUMENT_LINE_ID VARCHAR2(25),
SKU_CODE VARCHAR2(25),
QUANTITY VARCHAR2(10),
SUBINVENTORY VARCHAR2(25),
LOT_NUMBER VARCHAR2(25));
CREATE OR REPLACE EDITIONABLE TYPE XRCL_CB_INBOUND_TALLY_NT AS TABLE OF XRCL_CB_INBOUND_TALLY_OBJ;
下面是我作為引數傳遞的 json 物件：
{
"TALLYQUANTITY_Input": {
"RESTHeader": {
"Responsibility": "ROCELL",
"RespApplication": "XRCL",
"SecurityGroup": "STANDARD",
"NLSLanguage": "AMERICAN"
},
"InputParameters": {
"P_TRANSACTION_LINES": [
{
"TRANSACTION_TYPE": "IO",
"TRANSACTION_DATE": "01/02/2022 12:00:00 AM",
"ORGANIZATION_ID": "121`enter code here`",
"DOCUMENT_ID": "1",
"DOCUMENT_LINE_ID": "1",
"SKU_CODE": "RC.001.000102.MA.03",
"QUANTITY": "1",
"LOT_NUMBER": "1013A.B.7.J.G",
"SUBINVENTORY": "Saleable"
}
]
}
}
}
uj5u.com熱心網友回復：
通過以與 xsd序列標記中定義的相同順序傳遞引數來解決問題
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/428102.html
標籤：甲骨文
上一篇：如何在Oracle中重命名序列？