I was thinking it might be useful, either as a one-time-use generator, or in the .xql file. The .xql is what gets edited anyway if a package is converted from Oracle. If a tcl proc was inserted there instead, then package maintainance would be more centralized.
I looked around and noticed that some .xql files already have tcl code togeather with other sql fragments.
One thing I don't quite get with ACS is that there is no real standard for updating data, or checking that an object is of the right type before being deleted, or resetting data to it's default value.
For instance, if you create a user and then change the user's password, you should be able to do that through the same package used to create the user. Instead, you have to know what table the password is in and update it there.
