# 3172 Creating or Dropping Tables Can Cause #901 Errors in Functions Used in Triggers

---

I've had to reports just recently from two different users that had 901 error with a description indicating that there was an attempt to execute a unprepared procedure.

I have not been able to duplicate the issue outside of our application, but I have more details and believe that it has to do with temporary tables. More specifically the creation and/or deletion of temporary tables and it somehow resetting the previously prepared functions.

The function I've been focusing on is the same one that I sent previously which just strips the body tags off of HTML before it is saved down. The function is only called from either the BeforeInsert or BeforeUpdate triggers that I have on the table.

In my app, I have a window that allows DataAware editing of the table via a TEDBTable object. If I open up that window, it opens the table and prepares the HTMLBody function. Everything is OK up to this point and everything works perfectly until something changes in the database. If I run the script below AFTER I have opened up the table, it throws the 901 error when attempting to post to the table.