We have our application in C with Sybase Database. While running the application, at times it thorws an error (sqlcode -540) with error message
"Schema for table <table-name> has changed since compilation of this query. Please re-execute query."
This error occurs when it is trying to open select cursors on a particular table. We never changed the schema was during execution, and update statistics on the table was not done during execution.
Our Sybase version is 11.1.1.
Does this error has got something to do with the Sybase version?