Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: pl/sql - update problem
IF SQL%ROWCOUNT > 0 THEN
dbms_lob.......
END IF;
-- Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications. All opinions are mine and do not necessarily go in line with those of my employer. "Jim Poe" <jpoe_at_fulcrumit.com> wrote in message news:MPG.183c2d68a46e248e989689_at_news.telepacific.net...Received on Wed Nov 13 2002 - 13:23:10 CST
>
> 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>