PL/SQL - Without closing the cursor, If you want to open it what will happen. If error, get what is the error

GeekInterview.com > Interview Questions > Oracle > PL/SQL

Go To First | Previous Question | Next Question

PL/SQL | Question 159 of 241

Without closing the cursor, If you want to open it what will happen. If error, get what is the error?

Total Answers and Comments: 5

Last Update: March 18, 2009 Asked by: ddkdhar

Sponsored Links

Best Rated Answer

—

Submitted by: madhaviguthula

If you reopen a cursor without closing it first,PL/SQL raises the predefined exception CURSOR_ALREADY_OPEN.

Above answer was rated as good by the following members:
manish.baehal, samareshp

March 05, 2007 06:58:31

madhaviguthula

Member Since: February 2007 Contribution: 7

RE: Without closing the cursor, If you want to open it...

If you reopen a cursor without closing it first PL/SQL raises the predefined exception CURSOR_ALREADY_OPEN.

Is this answer useful? Yes | No

2 0

Overall Rating: +2

September 09, 2007 17:11:26

Sirisha

RE: Without closing the cursor, If you want to open it...

It is legal to open an already opened cursor. When we try to open an already opened cursor the cursor when it is initially opened is automatically closed and again opened.

Is this answer useful? Yes | No

0 3

Overall Rating: -3

May 03, 2008 05:04:32

krishnaindia2007

Member Since: September 2007 Contribution: 854

RE: Without closing the cursor, If you want to open it what will happen. If error, get what is the error?

It throws error message
ORA-06511: PL/SQL: cursor already open

Is this answer useful? Yes | No

October 10, 2008 13:35:56

ratna82

Member Since: October 2008 Contribution: 2

RE: Without closing the cursor, If you want to open it what will happen. If error, get what is the error?

CURSOR_ALREADY_OPEN ORA-06511 An attempt was made to open a cursor that was already open.

Is this answer useful? Yes | No

March 18, 2009 05:44:34

msenthil19

Member Since: March 2009 Contribution: 3

RE: Without closing the cursor, If you want to open it what will happen. If error, get what is the error?

Error will be like "Cursor already open"

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank