sasidhardoc wrote:

> My question is, if I run these as SQL queries from the application, I
> can run them inside a transaction - and, rollback in the event of an
> error.
> However, I have no control over SP (right?). So, this SP may run few
> of the internal SP and insert some records - then there is an error -
> there is no mechanism for rollback - right? Will this not leave the Db
> in an inconsistent state?

Absolutely not. The whole invocation of a stored procedure - and any
procedures it calls - is a single statement and succeeds or fails as a
unit. Stored procedures will never leave partial results in the database.

Regards,


Ann