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.