Transaction and procedure external

[kiroki]

Hi

I have a transaction block and a procedure external.. I want that the procedure external was commit and not the transaction block... how can I do ???

Thank you to your help...

 

[joey.jeremiah]

you cant commit some parts and roll some others, transactions are an all or nothing deal and they should be.

if the scope of the transaction is bigger then whats needed then by all means break them down into smaller transactions.

 

[MDaanje]

If possible: Use buffers for the tables you want to update/add/delete records from, then you can break down transaction blocks and you'll have more control over it.

 

[bulklodd]

Hi

I have a transaction block and a procedure external.. I want that the procedure external was commit and not the transaction block... how can I do ???

Thank you to your help...

The only way is to run your external procedure in another session. You can use asynchronous call via appserver but it's the same anyway.