remove CURSOR STATEMENT : 1 from printing out



I have created a package the returns a ref cursor. The package is as
follows:
CREATE OR REPLACE PACKAGE p_storedivreg_hist is

-- Author : JEFFC
-- Created : 6/20/2005 9:20:18 AM
-- Purpose : Get division history for a store based on a date

-- Public type declarations
type resultset is REF CURSOR;


-- Public function and procedure declarations
function results(dbctr_in NUMBER)
return resultset;

end p_storedivreg_hist;


create or replace package body p_storedivreg_hist .
is

-- Function and procedure implementations
function results(dbctr_in NUMBER)
return resultset IS
rset p_storedivreg_hist.resultset;
BEGIN
OPEN rset FOR
SELECT c.dbdiv, r.dbctr dbreg
FROM centers c, centers d, centers r
WHERE c.dbctr = dbctr_in
AND c.dbdiv = d.dbctr
AND d.dbdiv = r.dbctr
AND c.dbdate = (SELECT MAX(dbdate) FROM centers
WHERE dbdate <= SYSDATE
AND dbctr = c.dbctr)
AND d.dbdate = (SELECT MAX(dbdate) FROM centers
WHERE dbdate <= SYSDATE
AND dbctr = d.dbctr)
AND r.dbdate = (SELECT MAX(dbdate) FROM centers
WHERE dbdate <= SYSDATE
AND dbctr = r.dbctr);

RETURN rset;

end;

end p_storedivreg_hist;

When I run it in sqlplus;
select p_storedivreg_hist.results(32) from dual;


I get:
CURSOR STATEMENT : 1

CURSOR STATEMENT : 1

DBDIV DBREG
---------- ----------
1683 2943



My question is how do I get rid of the text CURSOR STATEMENT : 1 ???

.



Relevant Pages