Multiple choice technology databases

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

  1. INVALID_CURSOR

  2. CURSOR_ALREADY_OPEN

  3. TIMEOUT_ON_RESOURCE

  4. SYS_INVALID_ROWID

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In PL/SQL, attempting to open a cursor that is already open raises the CURSOR_ALREADY_OPEN exception. This is a predefined exception that occurs when you try to open an already-open cursor without closing it first.