how to update emp_name using implicit cursor

[Former Member]

how to update emp_name using implicit cursor in oracle.

for this purpose i wrote a program in pl/sql

DECLARE  
 var_names VARCHAR2(30);
BEGIN
  UPDATE emp
  SET emp_name= emp_name +'garu';
  IF SQL%NOTFOUND THEN
    dbms_output.put_line('None of the salaries where updated');
  ELSIF SQL%FOUND THEN
  var_names:=sql%rowcount;
    dbms_output.put_line('Salaries for ' || var_names|| 'employees are updated');
  END IF; 
END;

but showing error,that is

Error report:
ORA-01722: invalid number
ORA-06512: at line 4
01722. 00000 -  "invalid number"
*Cause:    
*Action:

can any one clarify my doubt..

[reimer_pods]

This forum is focused on SAP Sybase SQL Anywhere. Please find an appropriated forum for Oracle questions and post your question there.
Have a look at Oracle Database