Transactions outside a Stored Procedure

Thread view:

Enable EMail Alerts

Start New Thread

Dave - 14 Oct 2006 17:05 GMT

Is it OK to use transactions outside a stored procedure? For example, as
part of a standard SQL statement using JDBC?

Reply to this Message

Arne Vajhøj - 14 Oct 2006 17:28 GMT

> Is it OK to use transactions outside a stored procedure? For example, as
> part of a standard SQL statement using JDBC?

Of course it is OK. I even think it is relative common
to bundle multiple SQL statements in one transactions.

Arne

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...