That's true about drivers. That's why odal has ModelLoader/Storer Plugin interfaces to load information about user defined types, which are database specific. There is also oracle implementation for it. We could add another plugin type to the meta-data loader/storer to handle SPs meta-data + structure to the MetaModel. That could be used later to generate artifacts. Good luck.
There is no problem with objects that map to tables. Use PersistentDescriptorGenerator that takes odal/src/config/templates/persistent-descriptor-config.properties as a parameter.That will generate descriptors with POs meta-data. If no changes are needed, you can immediately generate objects with PersistentObjectGenerator feeding it odal/src/config/templates/persistent-object-config.sdl. You can...