| error in procedure code [message #312644] |
Wed, 09 April 2008 09:14  |
RRRR
Messages: 6
Registered: April 2008
|
Junior Member |
|
|
please what is the error in this procedure cod
| Quote: | create or replace procedure delproc is
cursor del_cur is
select * from employees where salary >= 450;
for update;
cur_row del_cur%rowtype;
begin
open del_cur;
loop
fetch del_cur into cur_row
exit when (del_cur%notfound);
delete from employees where current of del_cur;
end loop;
close del_cur;
end delproc;
/
|
when i execute it :
Procedure created with compilation errors.
and when i make show errors:
PLS-00103: Encountered the symbol "FOR" when expecting one of the
following:
begin function package pragma procedure subtype type use
<an identifier> <a double-quoted delimited-identifier> form
current cursor
thank you 
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
