pl/sql - update problem

From: Jim Poe <jpoe_at_fulcrumit.com>
Date: Wed, 13 Nov 2002 09:36:12 -0800
Message-ID: <MPG.183c2d68a46e248e989689@news.telepacific.net>

This is part of my pl/sql procedure:

---

    else

      update rb_item set item_size = vItemSize,
                         folder_id = vFolderId,
                         item_name = vItemName,
                         template = empty_clob(),
                         modified = ( sysdate - (to_date( '12/31/1899', 


'MM/DD/YYYY' ))),

                         revision = vRevision
      where item_id=vItemId and
            revision <> vRevision
        return template into l_blob;

    end if;

    dbms_lob.loadfromfile( l_blob, l_bfile, vItemSize );

    commit;

    dbms_lob.fileclose( l_bfile );

---

The question is, if there are 0 rows updated the 'loadfromfile' and
'commit' should not be called. How do I know if 0 rows were updated?

Thanks

-- 
Jim Poe
Fulcrum InteTech, Inc.
<jpoe_at_fulcrumit.com>

Received on Wed Nov 13 2002 - 11:36:12 CST