ramesh

ramesh

  • NA
  • 19
  • 46.8k

Procedure created with compilation errors.

Aug 13 2012 5:57 AM

  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?

Answers (1)