Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using DBMS_LOCK in distributed environment

Status
Not open for further replies.
forrozeiro

forrozeiro

Programmer
Sep 1, 2001
38
BR
Hi :)
When I call DBMS_LOCK.request with the release_on_commit parameter set to TRUE in a distributed transaction subordinate session I get this:

ORA-02089: COMMIT is not allowed in a subordinate

I did not commit in the subordinate, I only set for the lock to be released when the commit/rollback be executed.
Could anyone help me on that.
Thnx!!
 
Status
Not open for further replies.

Similar threads

rk68
  • Locked
  • Question
Data encryption in Oracle 19c
Replies
0
Views
308
rk68
rk68
Olutee360
  • Locked
  • Question
Group by using values in a range 1
Replies
4
Views
373
Olutee360
Olutee360
TheLazyPig
  • Locked
  • Question
Merge Into with multiple execution 1
Replies
1
Views
880
carp
carp
EM1107
  • Locked
  • Question
Insert date and time using UTC time in a DATE column
Replies
14
Views
2K
EM1107
EM1107
annie1975
  • Locked
  • Question
sql script in an cron job script failing
Replies
3
Views
510
carp
carp

Part and Inventory Search

Sponsor

Back
Top