Re: commit within function

On Thu, Jul 16, 2009 at 11:30 AM, Anj Adu<fotographs(at)gmail(dot)com> wrote:
> I need an explicit commit...i.e i need func B's results to be
> available to other transactions when I enter func C
>
> So...what you are saying is..in Func c
>
> BEGIN
>    simulate error
> EXCEPTION
>    WHEN condition [ OR condition ... ] THEN
>        do nothing;
> END;
>
> Will this cause the transaction to be committed upto the savepoint in
> the beginning of function C ?

The transaction will be committed or not as a whole. That's how
transactions work. If you need part of the data so far processed
committed then you need to commit the transaction and start a new one.