Re: help! ...compilation error running a simple procedure

I think you have written wrongly this stmt exit when getdata%notfound it should be exit when c1%notfound

regards
vittal

dnanda wrote:

> i'm in a fix ....i am trying to run a procedure which is not running on
> sql*plus 8.0
> create or replace procedure get_data(cl_no IN client_master.client_no%type)
> is
> cname client_master.name%type;
> cursor c1(cno) is select name from client_master where client_no=cno;
> begin
> open c1(cl_no);
> loop
> fetch c1 into cname;
> exit when getdata%notfound;
> end loop;
> close c1;
> end;
>
> this procedure is showing compilation errors and sometimes saying that the
> object already exists..i have also tried changing names.
Received on Thu Apr 15 1999 - 08:52:34 CDT