[closed] how to update emp_name using implicit cursor

-1

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..

oracle cursor

asked 13 Sep '13, 01:57

ram34874
0●2●2●2
accept rate: 0%

closed 13 Sep '13, 09:36

Mark Culp
25.0k●10●142●298

Comment Text Removed

flat view

The question has been closed for the following reason "Question is off-topic or not relevant" by Mark Culp 13 Sep '13, 09:36

One Answer:

active answers oldest answers newest answers popular answers

1	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 permanent link answered 13 Sep '13, 09:31 Reimer Pods 4.5k●38●48●91 accept rate: 11% edited 13 Sep '13, 09:34 flat view

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

oracle ×30
cursor ×24

question asked: 13 Sep '13, 01:57

question was seen: 2,041 times

last updated: 13 Sep '13, 09:36

SAP SQL Anywhere

[closed] how to update emp_name using implicit cursor

The question has been closed for the following reason "Question is off-topic or not relevant" by Mark Culp 13 Sep '13, 09:36

Follow this question

Related questions