Connecting to Your Database
Using Embedded SQL with Oracle

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.

Example

CLOSE dept_proc;