Oracle stored procedure, return recordset, declare cursor

I am very new to Oracle stored procedures. I am trying to return a recordset from my Oracle database using a SQL query (inside a stored procedure) with one input parameter. I understand I need to use a ref cursor, but I am having difficulty with compiling code based on examples I have seen here and other places on the web.

The concept is simple, I have a table of counties and there are 4 regions in the state. When the user submits a region (region_param), the stored procedure should return a list of counties. Eventually, this stored procedure will serve an XML-based web service and populate drop-downs, etc. I want to crawl before I run, though. I will ask how to return this to a web service once I get stored procedures figured out.

The error code I keep getting is "TYPES.cursorType must be declared." Here is the code I have so far...any help on syntax is appreciated!Start Free Trial

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:

CREATE OR REPLACE PROCEDURE getcounty
  (region_param IN NUMBER,
   resultset out TYPES.cursorType)
 
AS BEGIN
 
OPEN resultset FOR
 
    SELECT co_name
    FROM county
    WHERE county.region = region_param;
 
END getcounty;