Forum .LRN Q&A: Response to problem when posting to a forum

Collapse
Posted by Deds Castillo on
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... =)