Re: problem on ASA9 when modifying a procedure called by another

#1

If you were using version 11, you could use:
alter procedure procedure1 recompile
Unfortunately, this statement is not available in version 9. sa_flush_cache will
have no effect.

SQL Anywhere Developer Community:
http://www.sybase.com/developer/libr...ere-techcorner

SQL Anywhere Blog Center: http://www.sybase.com/sqlanyblogs

ps wrote:

Quote:

Hi
Using ASA 9.0.2; we have the following
procedure1 calls procedure2. Both of then are NON DETERMINISTIC.
If I change the content of procedure2, procedure1 seems to keep the
result of the old version of procedure1. So when I change
We tried sa_flush_cache(), but it does not work for this.
Is there a way to regenerate ALL stored procedures? Or to reset the
cache ? At the moment, I have to add speces to all calling procedures to
have a consistent result.
PS : if the DB content changes ( affecting procedure 2), then procedure
1 works correctly immediately.

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: problem on ASA9 when modifying a procedure called by another

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general

Re: problem on ASA9 when modifying a procedure called by another - 10-08-2009 , 09:54 AM