79499929

Date: 2025-03-11 07:28:21
Score: 1
Natty:
Report link

As a workaround I manage to use dynamic sql:

CREATE OR REPLACE PROCEDURE p_json_test(v_id_1 NUMBER, v_id_2 NUMBER) IS
    v_sql VARCHAR2(4000);
BEGIN
    v_sql := 'INSERT INTO JSON_RESAULT_TABLE
              SELECT ID, JSON_OBJECT(*)
              FROM JSON_TABLE
              WHERE ID IN (:1, :2)';

    EXECUTE IMMEDIATE v_sql USING v_id_1, v_id_2;
END;
/

execute p_json_test(1, 2);

This approach solve an issue

Reasons:
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: Kamil Raszkowski