> I think classic and superclassic do not support meta data change while in use, only superserver support it.

You have to use script to change procedures. Clients will see/use the old version until reconnect.
Not so easy with tables though.