coldfusion-cfscript-storeproc.cfc

function getSearchResultsSP(tax_year, search_str, user_id, sys_id, sys_privs) {

sp = new storedproc();
sp.setDatasource(Application.DSN_GDX); 
sp.setProcedure("PKG_GAIN_LOSS.GET_SEARCH_RESULTS"); 
sp.addParam(TYPE = "IN", CFSQLTYPE="CF_SQL_INTEGER", VALUE=tax_year, DBVARNAME="P_TAX_YEAR"); 
sp.addParam(TYPE = "IN", CFSQLTYPE="CF_SQL_VARCHAR", VALUE=search_str, DBVARNAME="p_search_str");
sp.addParam(TYPE = "IN", CFSQLTYPE="CF_SQL_VARCHAR", VALUE=user_id, DBVARNAME="p_userId");
sp.addParam(TYPE = "IN", CFSQLTYPE="CF_SQL_VARCHAR", VALUE=sys_id, DBVARNAME="p_sysId");
sp.addParam(TYPE = "IN", CFSQLTYPE="CF_SQL_VARCHAR", VALUE=sys_privs, DBVARNAME="p_sysPrivs");
// add cfprocresult  tags ---> 
        sp.addProcResult(NAME = "les",resultset=1); 
        //p_cursor 
// execute stored proc---> 
        result = sp.execute();
        listOfHits = result.getProcResultSets().les; 
return listOfHits;
}