Re: Will This Work?

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Thu, 30 Sep 1999 00:11:38 +0200
Message-ID: <938643182.16661.0.pluto.d4ee154e@news.demon.nl>

Hi,

You'll still need to FETCH into number_anis to accomplish what you want. Hth,

--
Sybrand Bakker, Oracle DBA
Johnny Sloans Jr. <jsloans_at_cticallcenter.com> wrote in message = news:MPvI3.102$Pp1.30412_at_feed.centuryinter.net... Hi,
I was wondering if the following code will work. I want to pass in 3 = parameters to this stored procedure on Oracle 8. I need it to return = just one value back. Will it work?

PROCEDURE el_sp_aadr1(B_date_in IN NUMBER,E_date_in IN = NUMBER,sismas_in IN NUMBER, rec_count_out OUT NUMBER) IS

BEGIN DECLARE number_anis NUMBER;

CURSOR record_cur IS

SELECT count(distinct ani) number_anis

FROM admin1.el_commission

WHERE to_char(call_date,'yyyymmdd') between B_date_in and E_date_in

and sismas = sismas_in

and ratp6 = 1 and rarev > 0;

BEGIN OPEN record_cur;

rec_count_out := number_anis;

CLOSE record_cur;

END; END el_sp_aadr1;

  Johnny L. Sloans Jr.,
  MIS, CenturyTel Inc.
  jsloans_at_cticallcenter.com Received on Wed Sep 29 1999 - 17:11:38 CDT