On Wed, May 26, 2010 at 2:52 AM, Ravi Katkar <Ravi.Katkar@infor.com> wrote:
> How can we achieve nested transactions? ( may be using save points )with in functions.
> Is there any work around?
It unfortunately can't be done from within the database. There is
only one workaround -- using dblink or similar technology to connect
back to the database inside your function to bend/break transaction
rules.
In the 9.0 world, this (no implicit transaction state pl code,
possibly termed 'stored procedures') is one of the top two or three
requested features.
merlin