PL/SQL-question
Posted: Fri Apr 15, 2005 2:55 pm
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:
Is there anything awkward with it? It seems totally correct syntax-wise... 
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;
/