One error I found is in the message-post-oracle.xql, one query's
name is message_select, it should be select_date.
Other than that, code looks good. But I'm stumped on why I'm still
getting this error...
ora8.c:3568:ora_tcl_command: error in `OCIStmtExecute ()':
ORA-01400: cannot insert NULL into
("ROBS"."FORUMS_MESSAGES"."POSTING_DATE")
ORA-06512: at "ROBS.FORUMS_MESSAGE", line 50
ORA-06512: at line 4
... when my forums_messages packages clearly defines the default of
posting_date to be sysdate. I can't quite catch it yet but it's
less likely that this is an Oracle issue as I'm testing on two
different machines with two different Oracle installs. I think I
need more coffee... =)