Oracle CLOSE

If a database stored procedure has output parameters, it must be closed when processing is complete.

Closing a procedure looks the same as closing a cursor.

CLOSE dept_proc;