PL/SQL-question

[diego]

Hey community,

I try to write an explicit Cursor in PL/SQL but.. it just won't work. Here is the suspected part of Code:

Code: Select all

Begin
     Update wwage set wwage=wwage + 1000 where year = 98
     and month = 2;
	If SQL%found then
		DBMS_output.put_line ('amount of wages in February 98:' || SQL%rowcount);
	End if;
End;
/

Is there anything awkward with it? It seems totally correct syntax-wise...

[GONNAFISTYA]

Nerd.