SQL Prompt is showing an old version of my stored procedure

Ben PinchenBen Pinchen Posts: 158
edited June 28, 2007 10:48AM in Knowledge Base
When displaying the creation SQL for an object in the schema panel, or inserting SQL code into the query editor window, SQL Prompt uses the version of the SQL in its cache file; it does not retrieve the latest version from the database. This means that the SQL code may be out of date.

Because of this, if you auto insert an object definition after the ALTER statement and you have not updated your cache, it is possible to accidentally overwrite the new version of a stored procedure with the old version stored in the cache file. Therefore, when you are editing SQL code on a database for which the schema may have changed, ensure you refresh the cache before you use the auto insertion features.
Sign In or Register to comment.