Re: Will This Work?

From: Johnny Sloans Jr. <jsloans_at_cticallcenter.com>
Date: Thu, 30 Sep 1999 08:43:37 -0500
Message-ID: <5MJI3.157$Pp1.58547@feed.centuryinter.net>

Thank you
Sybrand Bakker <postmaster_at_sybrandb.demon.nl> wrote in message = news:938643182.16661.0.pluto.d4ee154e_at_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 Thu Sep 30 1999 - 08:43:37 CDT