Home » SQL & PL/SQL » SQL & PL/SQL » savepoint puzzle
savepoint puzzle [message #239836] Wed, 23 May 2007 07:11 Go to next message
orafacjublu
Messages: 95
Registered: May 2006
Location: KOLKATA
Member
Can Any one give me the answer---

what If I forget the name of the SavePoint in oracle dml transactions? Is there any data dictionary view or table from where we can check the SavePoint names of an incomplete transaction?
Re: savepoint puzzle [message #239837 is a reply to message #239836] Wed, 23 May 2007 07:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is none (afaik).

But how could you lose the name of a savepoint? Isn't it in your program?

Regards
Michel
Re: savepoint puzzle [message #239952 is a reply to message #239837] Wed, 23 May 2007 13:31 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
just scroll the scroller upward Wink
Re: savepoint puzzle [message #240114 is a reply to message #239952] Thu, 24 May 2007 03:02 Go to previous messageGo to next message
orafacjublu
Messages: 95
Registered: May 2006
Location: KOLKATA
Member
Then where does oracle saves the savepoint name until the transaction ends ????
Re: savepoint puzzle [message #240147 is a reply to message #240114] Thu, 24 May 2007 04:32 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Somewhere in its memory.

Regards
Michel
Previous Topic: DBMS_OUTPUT.PUT_LINE
Next Topic: How to pass hashmap as arguments to stored procedure
Goto Forum:
  


Current Time: Fri Dec 09 17:23:36 CST 2016

Total time taken to generate the page: 0.13742 seconds