Rest API response more than 100k data missing
DECLARE
V_START_DATE VARCHAR2(20) :='20241103000000';
V_END_DATE VARCHAR2(20) :='20241103000000';
V_ACC_NO VARCHAR2(50) :='20502130900020407';
V_TRAN_NO VARCHAR2(50) :='IBBWSTx11241111006720';
request UTL_HTTP.req;
response UTL_HTTP.resp ;
vresponse CLOB;
value VARCHAR2(32000);
V_URL VARCHAR2(32000);
V_STATUS NUMBER;
V_STATEMENT_FROM_DATE VARCHAR2(250);
V_STATEMENT_TO_DATE VARCHAR2(250);
V_STATEMENT_ACCNO VARCHAR2(250);
V_TRANSACTION_ACCNO VARCHAR2(250);
V_TRANSACTION_BRANCHCODE VARCHAR2(250);
V_TRANSACTION_TRANSID VARCHAR2(250);
V_TRANSACTION_TRANSDATE VARCHAR2(250);
V_TRANSACTION_PARTICULARS VARCHAR2 (250);
V_TRANSACTION_DRAMT VARCHAR2 (250);
V_TRANSACTION_CRAMT VARCHAR2 (250);
V_TRANSACTION_BALANCE VARCHAR2 (250);
V_TRANSACTION_REFCODE VARCHAR2 (100);
V_TRANSACTION_INSTRNO VARCHAR2 (150);
V_RECEIVABLE_ID VARCHAR2 (250);