OK, so technically, there is no reason why commit/rollbacks are not
supported in SP, it's just a decision that was made not to allow it?

Correct?

""Dmitry Yemanov"" <dimitr@...> wrote in message
news:<S1783262AbVFPGVG/20050616062113Z+602@...>...

> "Alan McDonald" <alan@...> wrote:
> >
> > transaction control has always been in the hands of the client
> application.
>
> Correct. EXECUTE PROCEDURE is a usual SQL statement and hence it must be
> atomic.
>
> > There are now SAVE points to be used within SPs but they are not
> completely
> > the same thing.
>
> Savepoints are not supported in PSQL.
>
>
> Dmitry
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>