你必须使用动态SQL，下面是你的起点，如果你的输入没有被 Package 在方括号中，然后扁平化，那么你将为每个JSON记录获得一行。然后简单地运行循环。

begin
let jsonstring varchar := '[{"level":1,"object":"OBJECT1","object_schema":"SCHEMA1","object_type":"TABLE"}, 
{"level":2,"object":"OBJECT2","object_schema":"SCHEMA2","object_type":"TABLE"}, 
{"level":3,"object":"OBJECT3","object_schema":"SCHEMA3","object_type":"TABLE"}]';

let sql varchar := 'select value:"level"::varchar level
    ,value:"object"::varchar object
    ,value:"object_schema"::varchar object_schema
    ,value:"object_type"::varchar object_type
    from (
        select parse_json(''' || jsonstring || ''') val
    ) n
    ,lateral flatten(n.val);';
    let res resultset := (execute immediate :sql);
    let c1 CURSOR FOR res;

    let lev varchar;
    let ob varchar;
    let ob_sc varchar;
    let ob_tp varchar;
    for i in c1
    do 
     lev:= i.level;
     ob:= i.object;
     ob_sc:= i.object_schema;
     ob_tp:= i.object_type;

    // Do what you want to do with values
    end for;
    
    return table(res);

end
;