CREATE OR REPLACE
PROCEDURE get_state (p_state IN sample_country_info.state_name%TYPE,
p_recordset OUT SYS_REFCURSOR) is
BEGIN
OPEN p_recordset FOR
SELECT country_id,
country_name,
FROM sample_country_info
WHERE state_name = p_state;
* end get_state;
when i run this program it shows procedure created with complilation error...
where is the error please help me?