Kbase P66012: Can I define the transaction isolation level inside a Stored Procedure ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/23/2004 |
|
Status: Unverified
GOAL:
Can I define the Transaction Isolation Level inside a Stored Procedure ?
FIX:
The isolation of the transaction is only defined for the connection object of the application thus this can not be defined in the Stored Procedure code or the trigger code since these by it's nature are executed bonded to the database.
What the code for the Trigger or Stored Procedure must do, is validate if the operation generated an error and return it back to the caller code.