I was waiting if some1 else answer u. Since no one yet, let me offer some view.
I think what is meant by moving smoothly across to Oracle procedure is to abstract out the interogation of the DB without touching source codes, which is given by PL/SQL of Oracle.
I dunno much of MaxDB, but if it has an SQL engine too, then if u understand the logic used by cooldog u should not find any issue to migrate those SQLs to your DB version.
U can try and update us back.