If we dont close the cursor we get error becoz once u open a cursor unless

hi..........i m Accenture employee...Accenture is an IT
company having itz branches in India at Mumbai, Pune,Delhi,
Hyderabad, Chennai and Bangalore....Presently there are
openings here for SAP, Testing, Oracle,Java,.NET,MAinframe
and Peoplesoft...... I am a software engineer working with
Accenture,Mumbai....u can mail me in your resume..i`ll
forward it to our HR team...my mail id:
pankit.lodaya@accenture.com

Question Posted / jyothi

8 Answers
37500 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / jyothi

If we dont close the cursor we get error becoz once u open a
cursor unless u close it search for another row cannot be
done. A cursor opened should be closed once the result for
that particular search is obtained.

Is This Answer Correct ?

6 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I run pl sql in sql developer?

1170

What is structural independence and why is it important?

1074

What is the function that is used to transfer a pl/sql table log to a database table?

1068

how can you see all indexes defined for a table? : Sql dba

1053

Explain isolation levels. : Transact sql

1107

What is the need of merge statement?

1092

How do you respond to dementia behavior?

1015

what is try_catch block in procedure

1808

What are the advantages of pl sql?

1166

What is the difference between clustered and non-clustered indexes?

1129

What are triggers in sql?

1061

What is data abstraction in sql?

1066

What is the basic structure of an sql?

1157

What is the purpose of the primary key?

1117

Write an sql query to select all records from the table?

1079