Forum OpenACS Development: Re: Content Repository problems on Oracle

Collapse
Posted by Don Baccus on
It sounds as though the basic CR API paradigm might be slightly broken, since CLOB/LOB columns can not be directly inserted (regardless of whether or not you're trying to do so using the auto-generated view for a content type).

It is necessary to do a two-step process, as Dave's saying perhaps is necessary. Yes, it is. Check out the old cr revision code that inserts a file into the database (or file system) to see this.

In order to make the writing of db-agnostic code possible the Tcl API should offer the two-step (INSERT of non-[C]LOB data followed by an UPDATE that adds the [C]LOB data) approach for both databases.