Unable to invoke ISG custom Rest service with Record type input
Hi Team,
We have the rest api defined which will accept a record type as input.
Below is the DDL for the record type:
create or replace TYPE JSON_HEADER_REC_TYPE IS OBJECT
( ProgramName VARCHAR2(240),
OrderId VARCHAR2(240),
OrderType VARCHAR2(240),
OrderStatus NUMBER,
TransactionID NUMBER,
BillTo JSON_BILLTO_TAB_TYPE);
/
create or replace TYPE JSON_BILLTO_REC_TYPE IS OBJECT
( Action VARCHAR2(30),
BillToName VARCHAR2(240),
OBANumber VARCHAR2(240));
/
create or replace TYPE JSON_BILLTO_TAB_TYPE IS TABLE of JSON_BILLTO_REC_TYPE;
/
PLSQL PACKAGE BODY:
CREATE OR REPLACE PACKAGE body XXEFX_C2O_JSON_TEST_PKG AS
/* $Header: $ */
FUNCTION upload (p_json_data in Json_Header_Rec_Type