I am facing an issue with passing a substantial amount of records as a stringify object from the client to the server. On the server side, there is a function named 'Get_Records' that is supposed to receive and process this string object by parsing it into individual records for necessary modifications. The following is an example of how the stringify function is called from the client side:
stringify(rec, "IS_TRANSACTION=${IsTransaction}^COMPANY_ID=${CompanyId}^PR_TRANSACTION_SEQ=${PrTransactionSeq}^SPRICE=${SPrice}^SQUANTITY=${SQuantity}^", JSON) into SelectionVar;
call Get_Records(SelectionVar) into invoiceExist;
Below is the function on the server side responsible for capturing the string object:
FUNCTION Get_Records(
selection_string_ IN VARCHAR2 ) RETURN VARCHAR2
IS
records_ json_array :=
json_array.parse(selection_string_);
current_selection_ VARCHAR2(32000);
BEGIN
//Code
END;
However, I am encountering an error when attempting to pass a large number of records from the stringify() function. The server side function 'Get_Records' fails to capture the data and returns an error message stating, 'unimplemented or unreasonable conversion requested, details: undefined undefined'. I have tried using the 'CLOB' datatype for the server side function, but it does not work for handling a significant volume of records. Is there a more effective way to transmit the string object received from the stringify function to the server side?