Trying etp (OpenACS 5.1) with Oracle I have found a couple of serious problems, starting from the create script (wich uses the PostgreSQL syntax 'content_type__create_type' instead of 'content_type.create_type') and continuing with etp-edit-oracle.xql where the query get_standard_attribute lacks the required column mime_type.
Now I'm stuck with:
nsoracle.c:3904:ora_tcl_command: error in `OCIStmtExecute ()': ORA-01465: invalid hex number
SQL:
update cr_revisions
set content = !>>>!value
, mime_type=:mime_type
where revision_id = :revision_id
Before continuing I'd be happy to know if someone is already using etp with Oracle and eventually willing to share his correct code.
I read in a recent posting that some CR problems with Oracle has been fixed. Wich is the fixed version, HEAD or what else?
Claudio
