OraFAQ Forum: SQL & PL/SQL » savepoint puzzle

Home » SQL & PL/SQL » SQL & PL/SQL » savepoint puzzle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

savepoint puzzle [message #239836]

Wed, 23 May 2007 07:11

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?

Report message to a moderator

Re: savepoint puzzle [message #239837 is a reply to message #239836]

Wed, 23 May 2007 07:17

Michel Cadot
Messages: 68641
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

Report message to a moderator

Re: savepoint puzzle [message #239952 is a reply to message #239837]

Wed, 23 May 2007 13:31

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

just scroll the scroller upward Wink

Report message to a moderator

Re: savepoint puzzle [message #240114 is a reply to message #239952]

Thu, 24 May 2007 03:02

orafacjublu
Messages: 95
Registered: May 2006
Location: KOLKATA

Member

Then where does oracle saves the savepoint name until the transaction ends ????

Report message to a moderator

Re: savepoint puzzle [message #240147 is a reply to message #240114]

Thu, 24 May 2007 04:32

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Somewhere in its memory.

Regards
Michel

Report message to a moderator

Previous Topic:	DBMS_OUTPUT.PUT_LINE
Next Topic:	How to pass hashmap as arguments to stored procedure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 06:19:44 CDT 2024