I'm using the hibernate hilo generator ( article about hi/low algorithm FYI: http://ejbutils.sourceforge.net/article.html)

I have users that wish to add columns to my database via PL/SQL rather than using my hibernate objects.

I think a good approach would be to implement the high/low algorithm in a stored procedure. Anyone got an implementation handy? Any ideas on how difficult it would be to make a Java stored procedures reusing hibernate code? How do others deal with this problem?

I cannot use native oracle sequences because of a future requirement to support SQL server.

Thanks for any insights.