Nima,
Can hibernate translate plpgsql to pl/sql or the reverse? OpenACS definitely does not lend itself to a transparent peristence layer. You would not be happy with the performance compromise. It would really require a redesign of OpenACS.
Of course, if you minimize use of pl/sql and use more standard SQL newer versions of Oracle will have easier support.
