While it is possible as mentioned, I like to prefer a library of sub routines with specific names, that you can just include in your calling program. It may be easier to maintain and can provide less fear of wrong-doing or less debugging.
I see this as a distributed library implementation. Would love to know about better ways of implementing this, so I can use this to my own projects.
Maybe the better approach would be to store and retrieve modules from the database, and overload use or require to correctly load your module from the database.
Anyway, I would love to read more about this approach, and about distributed shared perl modules.