remove CURSOR STATEMENT : 1 from printing out

From: <jeffchirco_at_gmail.com>
Date: 27 Jul 2005 16:28:29 -0700
Message-ID: <1122506909.505818.94590_at_g44g2000cwa.googlegroups.com>

[Quoted] 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 ??? Received on Thu Jul 28 2005 - 01:28:29 CEST