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

On Wed, 14 Apr 1999 19:37:09 -0600, Ron Reidy <rereidy_at_uswest.net> wrotf:

I think the paramer to the cursor should have a datatyppe

i.e.

cursor c1(cno client_master.client_no%type) is select name from client_master where client_no=cno;

The getdata%notfound should be c1%notfound

>
>
>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 May 05 1999 - 12:49:57 CDT