I'm having exactly the same problem with forum postings.
I have installed dotLRN using the latest CVS (for OpenACS + dotLRN packages, as per instructions) with AOLServer 3.3ad13 and Oracle 8.1.7 on RH Linux 7.2 (although Java & InterMedia were added to Oracle after the initial Oracle install).
I also noticed that the demo Collaboraid dotLRN site (http://dotlrn.collaboraid.net/register/guest-user-login) has a problem with posting into a forum (although I can't confirm it's the same one, as no debug info is shown). I then tried the SloanSpace dotLRN guest account, and could post a new message, but when I tried deleting it, the systen produced a Request Error (I have shown only the first 10 or so lines)
Error Message: ------------------
ora8.c:3930:ora_tcl_command: error in `OCIStmtExecute ()': ORA-02292: integrity constraint (SSV2.NOTIF_REPONSE_ID_FK) violated - child record found
ORA-06512: at "SSV2.ACS_OBJECT", line 104
ORA-06512: at "SSV2.FORUMS_MESSAGE", line 131
ORA-06512: at "SSV2.FORUMS_MESSAGE", line 166
ORA-06512: at line 3
SQL:
declare begin
forums_message.delete_thread(:message_id);
end;
while executing
"ns_ora dml nsdb0 {
End: ------------------
While I can implement the fix described by Deds, is the problem a dotLRN one, or is something else (I noticed the questions about OpenACS Oracle driver, but there has not yet been a reply)?