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.. Comment Text Removed
|
The question has been closed for the following reason "Question is off-topic or not relevant" by Mark Culp 13 Sep '13, 09:36
This forum is focused on SAP Sybase SQL Anywhere. Please find an appropriated forum for Oracle questions and post your question there. |