SQL & PL/SQL

Hi,

I'm kind of lost trying to pass parameters into an oracle stored procedure. I have a a coldfusion function that calls a sp. How do I pass the parameters, and how do I modify the stored procedure to accept and return a recordset?

CF Function:
<cffunction name="getSubCategories">
<cfstoredproc procedure="pkg_subcategories.get_subcategories" datasource="#application.dsn#">
<cfprocresult name="get_subcategories">
<cfprocparam dbvarname="subcategoryID" value="#arguments.subcategoryID#">
</cfstoredproc>

<cfreturn get_subcategories>
</cffunction>

Ora package. How do i access the proc parameter?:

/*
create or replace
package pkg_filterSubcategories
as
type cursorType
is ref cursor;

function get_filterSubcategories
return cursorType;

end;
/

create or replace
package body pkg_filterSubcategories
as

--*****************************************
function get_filterSubcategories
return cursorType
as
cursor_filterSubcategories cursorType;
begin

open cursor_filterSubcategories
for

SELECT s.subcategoryID, s.subcategory, s.color_min, s.color_max
FROM filter_subcategories s, reports r
WHERE s.subcategoryID = r.subcategoryID AND
s.active <> 0 AND
s.color_min IS NOT NULL AND
s.color_max IS NOT NULL AND
s.type = 'PERCENT'
GROUP BY s.subcategoryID, s.subcategory, s.color_min, s.color_max
ORDER BY s.subcategoryID;

return cursor_filterSubcategories;

end get_filterSubcategories;

end pkg_filterSubcategories;
/

*/