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

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;

What type of data is a "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 Wed Apr 14 1999 - 20:37:09 CDT