Hi,

> Can anybody tell me, how to use a transaction in a SP.
> As, it is done in SQL server i.e. begin/commit/Rollback transaction

You can't.

Transactions are controlled by the calling application.


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com