I believe that part of the documentation is incorrect. Try this instead of:
samplenote::new db_1row do_insert { *SQL* }
do this:
db_exec_plsql do_insert { *SQL* }
You also might want to check and see if this is in the bugtracker. This should be filed as a bug if it isn't already. I believe Joel knows about this and plans to fix it.