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

What is the usage of when clause in trigger?

993

what is bdb (berkeleydb)? : Sql dba

976

what is offset-fetch filter in tsql? : Transact sql

896

Explain the savepoint statement.

1042

How do I remove duplicates in two columns?

979

What is the most common sql injection tool?

999

What is the purpose of using pl/sql?

1079

how to convert character strings to dates? : Sql dba

987

What is a schema? How is it useful in sql servers?

1044

What are few of the schema objects that are created using PL/SQL?

971

What is sql mysql pl sql oracle?

1028

Why is stored procedure faster than query?

910

How do I sort a table in sql?

985

How to select all records from the table?

1071

how to present a past time in hours, minutes and seconds? : Sql dba

946