CREATE OR REPLACE PROCEDURE get_stores (p_state IN stores.state%TYPE, p_recordset OUT SYS_REFCURSOR) AS BEGIN OPEN p_recordset FOR SELECT stor_name, stor_address, cityFROM stores WHERE state = p_state ORDER BY city; END; /