| seema |
Posted: Jun 26, 2008 03:02:32 AM |
Total Post: 62
Joined: Jan, 2008
|
| How many savepoint we can create at a time! |
|
|
 Gitesh |
| Posted: Jun 26, 2008 04:20:09 AM |  |
|
Total Post: 322
Joined: May, 2005
|
You can make r&d on same. Create anonymus PL/SQL block with for loop. execute insert value in table with savepoint within loop and trace your session with following command.
alter session set events 'immediate trace name savepoints level 1';
Trace file will be generating in user_dump_destination.
|
|
|
|
|
| seema |
| Posted: Jun 26, 2008 07:37:27 AM | |
|
Total Post: 62
Joined: Jan, 2008
|
I read in the book that we can do only 5 savepoint at a time.
Is it true? if yes then how?
|
|
|
|
|
| seema |
| Posted: Jun 26, 2008 07:38:15 AM | |
|
Total Post: 62
Joined: Jan, 2008
|
I read in the book that we can do only 5 savepoint at a time.
Is it true? if yes then how?
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
