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 Mike Lewis 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
0
0
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

Olutee360
  • Locked
  • Question
Group by using values in a range 1
Replies
4
Views
86
Olutee360
Olutee360
TheLazyPig
  • Locked
  • Question
Merge Into with multiple execution 1
Replies
1
Views
156
carp
carp
EM1107
  • Locked
  • Question
Insert date and time using UTC time in a DATE column
Replies
14
Views
293
EM1107
EM1107
annie1975
  • Locked
  • Question
sql script in an cron job script failing
Replies
3
Views
94
carp
carp
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
116
Livia8
Livia8

Part and Inventory Search

Sponsor

Back
Top