| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.tools -> 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
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
![]() |
![]() |