Can implicit cursors opened by SELECT,INSERT etc on Oracle 9.2.0.1 be closed without closing the connection to database .These cursors remain open even after the Stored procedure from which the SELECT,INSERT,UPDATE and othe DML statements are executed.

Does this require tuning the database.

Please reply at the earliest.

Its Urgent.

Regards

RAHUL

Oracle LazyDBA home page