[ask]: what wrong with my store procedure

From: earthlink <phil_at_amax.com>
Date: Wed, 17 Mar 1999 10:25:50 -0800
Message-ID: <7cos9p$saf$1@fir.prod.itd.earthlink.net>

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;
/ Received on Wed Mar 17 1999 - 12:25:50 CST