First, thank you for finding this error and looking for a solution.
It is not the case that work occurs on PostgreSQL while neglecting Oracle. It is possible that not every developer has the resources to maintain an Oracle installation for testing purposes. This is why it is so important for those who use Oracle to kindly volunteer to test before a release. With this information we can improve OpenACS.
On the LOB issue. It is interesting that the code orginally written for ACS does not work. It appears that content::revision::new can not use the view to set the content of the CLOB column. In this case we should change the procedure to use a two step process where the content is set as an update to the revision. Thank you for tracking this down.
