Home » SQL & PL/SQL » SQL & PL/SQL » Re: Cursors in Procedures
Re: Cursors in Procedures [message #36452] Wed, 28 November 2001 20:49
Messages: 46
Registered: November 2001
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;
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 May 20 13:34:47 CDT 2024