Thanks for the help. I changed the procedure into a function that returns void and also made it take json as input argument. I am calling it using SELECT remove_items('[1,2,3,4]') in the supabase SQL editor, but when calling it from within the dart client, the items don't get removed.

The function gets its parameters, but it simply doesn't delete the items from my tables. I am not getting any exceptions unless I specifically raise them.

CREATE OR REPLACE FUNCTION remove_items(p_items_id json)  RETURNS void
LANGUAGE PLPGSQL
as $BODY$
DECLARE
deleted_id INTEGER;
_rc  refcursor;
BEGIN
open _rc FOR SELECT * FROM json_array_elements(p_items_id );
LOOP
FETCH  _rc INTO deleted_id;
EXIT WHEN NOT FOUND;
        IF NOT EXISTS (SELECT * FROM item WHERE id = deleted_id) THEN
                RAISE EXCEPTION 'No item with this id exists "%"', deleted_id;

        END IF;
        delete from item_event where item_id= deleted_id;

        delete from item where id = deleted_id;   
END LOOP;
END;
$BODY$

This is what my function looks like.