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
37258 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 can we repair a mysql table? : Sql dba

979

What are triggers and its types?

1062

Is sql open source?

972

What are dml commands?

1020

Can we rollback delete command?

984

Can we use insert statement in function?

999

what is acid property in database? : Sql dba

1029

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1080

Which data dictionary views have the information on the triggers that are available in the database?

1236

give the syntax of grant and revoke commands? : Sql dba

1149

How do you sort in sql?

1026

What are the two types of cursors in pl sql?

1082

Can a foreign key be a duplicate?

911

What is the difference between alter trigger and drop trigger statements?

1109

Is sql dba a good career? : SQL DBA

991