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

----------------------------------------------------------------------

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 25 01:14:25 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.