DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Snippets has posted 5883 posts at DZone. View Full User Profile


  • submit to reddit
        // description of your code here

change this:

        db_dml revision_add {
            insert into mfp_notesi (item_id, revision_id, title)
            values (:item_id, :revision_id, :title)

for this:

        db_exec_plsql revision_add {
            select content_revision__new(:title, null, null, null, null, :title, :item_id, :revision_id, null, null, null)

        db_dml insert_note {
            insert into mfp_notes (note_id) values (:revision_id)