Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


Using DROP and REVOKE


Care must be taken if database objects are dropped when the CASCADE option is used and when REVOKE is used, particularly with respect to routines and modules.

It is important to bear in mind the following points in connection with modules and routines:

If an ident attempts to drop a routine for which there is a compiled version currently being held by another ident, the DROP operation will fail because the routine is in use.

When a routine is invoked, it is compiled and the compiled version of the routine is held by the invoking ident. Any other idents invoking a routine while a compiled version of it exists will use the existing compiled version and this will be held by them as well.

A compiled version of a routine will generally be held by an ident until the ident disconnects. If the routine invocation is contained in a dynamic SQL statement, deallocating the statement will release the compiled version of the routine immediately without the need for a disconnect.


Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX