Icon View Incident Report

Serious Serious
Reported By: Terry Swiers
Reported On: 3/18/2010
For: Version 2.03 Build 9
# 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.

Comments Comments
Any database catalog changes were causing the referenced function to be re-compiled, thus no longer properly prepared.

Resolution Resolution
Fixed Problem on 3/20/2010 in version 2.03 build 10

Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial