By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
DECLARE
v_548986 VARCHAR2(1000);
v_548984 VARCHAR2(1000);
v_548982 VARCHAR2(1000);
BEGIN
FOR c IN (
WITH t(arrWarnings) AS
(
SELECT JSON_QUERY('[
{
"type": "customer",
"existingCount": 2,
"createdCount": 0,
"partialSuccessCount": 0,
"erroredCount": 0,
"totalCount": 8,
"createdRecords": [
],
"existingRecords": [
"791304",
"2154046"
],
"error": {
},
"partialSuccessWarning": {
}
},
{
"type": "complaint",
"existingCount": 3,
"createdCount": 2,
"partialSuccessCount": 3,
"erroredCount": 0,
1 rows affected
dbms_output:
1
2 [TLM-TEST-SERIAL] does not exist or could not be loaded. [TLM-TEST-SERIAL] does not exist or could not be loaded. [TLM-TEST-SERIAL] does not exist or could not be loaded.