DECLARE
c_json CONSTANT json_array_t := json_array_t('[1, 2, 3]');
BEGIN
FOR i IN 0 .. c_json.get_size() - 1 LOOP
dbms_output.put_line(c_json.get_number(i))
END LOOP;
END; ORA-06550: line 6, column 5: PLS-00103: Encountered the symbol "END" when expecting one of the following: := . ( % ; The symbol ";" was substituted for "END" to continue.More Details: https://docs.oracle.com/error-help/db/ora-06550
DECLARE
c_json CONSTANT json_array_t := json_array_t('[1, 2, 3]');
BEGIN
FOR i IN 0 .. c_json.get_size() - 1 LOOP
dbms_output.put_line(c_json.get_number(i));
END LOOP;
END; Statement processed.
1
2
3
DECLARE
c_json CONSTANT json_array_t := json_array_t('[1, 2, 3]');
BEGIN
FOR i IN 1 .. c_json.get_size() LOOP
dbms_output.put_line(c_json.get_number(i));
END LOOP;
END; Statement processed.
2
3