The function
destroy-prepared-statement
destroys the prepared-statement
prepared-statement
and frees its resources. It should be called before closing the database associated with the prepared-statement. A destroyed prepared-statement can be reused by calling set-prepared-statement-variables with a new database.
LispWorks User Guide and Reference Manual - 21 Dec 2011