I work with cursor variables. I have Query1 and 3 CursorQueries assigned with 3 ref cursor variables in package procedure. How can I CLOSE open cursors? I try CursorQueriy.Close or Query1.Close but nothing.
Sandy, I'm not sure I'm understand your question. You question is 'How can I CLOSE open cursors?', but where do you want to close the cursors in the store procedure package or in delphi code? Why do you have to close the cursors?