| Subject | Re: [IBO] IB_SQL_IBO_4_7_Beta11 problem |
|---|---|
| Author | Helen Borrie |
| Post date | 2006-12-02T05:33:56Z |
At 03:48 PM 2/12/2006, you wrote:
cached. If you then alter the procedure, you will have to reset the
cache before being able to run the new version. (Reset the cache =
put the db offline and then online for Superserver, simply log off
and on again for Classic.)
Helen
>IB_SQL_IBO_4_7_Beta11.zipThat's inherent in the DB engine. Once you run a SP it is
>
>Everytime I update a procedure and run a Cursor SQL to test it,
>it says procedure in use when I repeat the process while building
>the same procedure. Have to disconnect and reconnect to continue
cached. If you then alter the procedure, you will have to reset the
cache before being able to run the new version. (Reset the cache =
put the db offline and then online for Superserver, simply log off
and on again for Classic.)
Helen