Home » SQL & PL/SQL » SQL & PL/SQL » Re: Cursors in Procedures
Re: Cursors in Procedures [message #36452] Wed, 28 November 2001 20:49
SS
Messages: 46
Registered: November 2001
Member
u need not declare cursor variable like 'c1' but u should see that it will not conflict with other variables declared.
after declare
cursor c is select * from emp where empid=EmpID;
begin
.........
but since in ur procedure u r giving empid=EmpID
there is no need for loop as fetch statement returns only one record

----------------------------------------------------------------------
Previous Topic: Re: how to insert into nested table?
Next Topic: write in a file in a distant computer
Goto Forum:
  


Current Time: Mon Mar 30 00:19:14 CDT 2020