urgent (closing ref cursor)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: urgent (closing ref cursor)

  1. #1
    Join Date
    Jun 2000
    Location
    chennai,tamil nadu,india
    Posts
    159
    When i try to close a ref cursor, it is not closing the cursor at all. i'm getting a ora error , which describes the error to be too many cursors open. do any one know why it is not closing the cursor inspite of so many close cursor statement in my pl/sql block.

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    I don't know the type of statement you run, but have you tried issuing a commit?

    Good luck.
    David Knight
    OCP DBA 8i, 9i, 10g

  3. #3
    Join Date
    Jan 2001
    Posts
    153
    Hi

    if u could clearly describe the oracle error message we can further dig on that..
    is this error message u getting..
    ORA-01000 maximum open cursors exceeded

    on the otherway..

    b4 u open the cursor issue an urcursor%isopen then close urcursor;

    if u could paste the code we can try to get some solution
    Vijay.s

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width