Re: bogus 710 error?

--- nigelc@Cognos.COM (Nigel Campbell) wrote: --- >During testing, I ran into repeated 710 errors (running Online 7.10UC1 on SUN) >for no apparent reason (that is, no tables are being renamed etc as 710 >implies). Trying to track it down I noticed that this error can appear if >my creation scripts raised any syntax errors in stored procedures prior >to running the tests. Finally, I moved one script which creates a series >of procedures (cleanly - no errors are flagged) after the script which >defines triggers (again - no errors). The triggers make no reference to >any of the procedures in the script file. > >Does this sound familiar? Obviously, I am now starting to break the >stored procedure script file down in the hopes of finding which >procedure may be causing problems as it is compiled. I just ran into a separate -710 instance which leads me to believe that the OnLine engine is being very sloppy about invalidating PREPAREd SQL statements. I had an ALTER TABLE statement fail because it could not obtain exclusive access to the particular table, that flagged all cached SPL procedures as invalid, despite the fact that the ALTER never occurred. If this is occurring only for stored procedures, try executing an UPDATE STATISTICS for the procedures in question. Paul Kapp ----> PLKapp@aol.com -OR- plk@interactive.visa.com