As Malte pointed out about azri, I have done some code changes at TCL as well as pl/sql packages which not only made the package more stable with respect to functionalities but also some new features have been added. The code rewrite uses content repository functions and procedures and overcomes locking problems experienced with earlier ETP.
The new features include a sidebar navigation system and display of ads with a new experimental global display. You can have a look at ETP at http://develop.sussdorff-roy.com/alumni .
The above mentioned problem was the first one I experienced but not the only one with ETP on oracle and creating a content type etp_page_revision does solve the problem.