Home » SQL & PL/SQL » SQL & PL/SQL » PLS-00302 for simple update???
PLS-00302 for simple update??? [message #38239] Wed, 03 April 2002 14:52 Go to next message
George
Messages: 68
Registered: April 2001
Member
Hi,

Could you please help me to fix this:

CREATE OR REPLACE PROCEDURE test AS
CURSOR c1 IS SELECT empno, sal as Employee from emp;
BEGIN
for i in c1
loop
begin
update emp set comm=1, sal = 20000 + i.sal where empno= i.empno;
exception
when others then
dbms_output.put_line('Error ');
end;
end loop;
END;

Thanks

Report message to a moderator

Re: PLS-00302 for simple update??? [message #38240 is a reply to message #38239] Wed, 03 April 2002 14:56 Go to previous message
George
Messages: 68
Registered: April 2001
Member
Sorry to post this, I found my mistake

Report message to a moderator

Previous Topic: PL/SQL Packages & Dynamic SQL
Next Topic: Extracting the digits after decimal from a float number
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 23:43:34 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.