Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> remove CURSOR STATEMENT : 1 from printing out

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@g44g2000cwa.googlegroups.com>


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

end p_storedivreg_hist;

create or replace package body p_storedivreg_hist . is

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 Wed Jul 27 2005 - 18:28:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US