Re: remove CURSOR STATEMENT : 1 from printing out

jeffchirco_at_gmail.com wrote:
> 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 ???

SELECT p_storedivreg_hist.results(32) AS MY_NEW_NAME FROM dual;

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)