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?