以下是我在PostgreSQL版本15中存储的过程:
CREATE OR REPLACE PROCEDURE customer_select(OUT customers REFCURSOR)
LANGUAGE plpgsql
AS $$
BEGIN
OPEN customers FOR
SELECT * FROM public.customers;
END;
$$;
在这里,我try 调用进程
CALL customer_select('customer_cursor');
FETCH ALL FROM customer_cursor;
但我收到了一个错误
ERROR: cursor "customer_cursor" does not exist
我怎么才能让它起作用呢?谢谢