On Thu, Jul 16, 2009 at 11:30 AM, Anj Adu<fotographs@gmail.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.