GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

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

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



March 03, 2007 06:58:31 #1
 madhaviguthula   Member Since: February 2007    Total Comments: 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.
     

 

Back To Question