CREATE OR REPLACE PROCEDURE authors_sel (
cv_results IN OUT SYS_REFCURSOR)
IS
BEGIN
OPEN cv_results FOR
SELECT id, first_name, last_name
FROM authors;
END;
/
CREATE OR REPLACE PROCEDURE authors_sel (
cv_results IN OUT SYS_REFCURSOR)
IS
BEGIN
OPEN cv_results FOR
SELECT id, first_name, last_name
FROM authors;
END;
/