remove CURSOR STATEMENT : 1 from printing out
- From: "jeffchirco@xxxxxxxxx" <jeffchirco@xxxxxxxxx>
- Date: 27 Jul 2005 16:28:29 -0700
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 ???
.
- Follow-Ups:
- Re: remove CURSOR STATEMENT : 1 from printing out
- From: DA Morgan
- Re: remove CURSOR STATEMENT : 1 from printing out
- Prev by Date: Re: Er modeling tool
- Next by Date: Re: remove CURSOR STATEMENT : 1 from printing out
- Previous by thread: com components in forms6i
- Next by thread: Re: remove CURSOR STATEMENT : 1 from printing out
- Index(es):
Relevant Pages
|