Re: [ask]: what wrong with my store procedure

From: <rsthomas_666_at_my-dejanews.com>
Date: Thu, 18 Mar 1999 02:08:17 GMT
Message-ID: <7cpn6b$iqc$1@nnrp1.dejanews.com>

In article <7cos9p$saf$1_at_fir.prod.itd.earthlink.net>, "earthlink" <phil_at_amax.com> wrote:
> hi, everyone,
> i'm new in Oracle programming.
> i just create some stored procedures.
> some procedures work, some don't.
> can you help me why this storee procedure won't work?
>
> p.s. I got compilation error from oracle.
> TIA
>
> Phil
>
> create or replace procedure t1
> is
> begin
> select count(*)
> from t_customer
> where person = 'father';
> end;
> /
>
>

create or replace procedure t1
is

li_count number(5);

begin

     select  count(*)
     into    li_count
     from    t_customer
     where person = 'father';

end;

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 17 1999 - 20:08:17 CST