| Creating Temporary Workarea [message #134027] |
Tue, 23 August 2005 06:15  |
paresh_p27
Messages: 1
Registered: August 2005
|
Junior Member |
|
|
Hi All
Is there any way ;where I can create a temporary work area which can be accessed by all sessions.
For example one session created a temporary table(can be any object) which contains some value. Is is possible that others sessions access/update that value without commit by the owner of this workarea.
Thanks in advance.
paresh
|
|
|
|
| Re: Creating Temporary Workarea [message #134490 is a reply to message #134027] |
Thu, 25 August 2005 03:49  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
Not possible - other session can only see COMMIT'ted data.
If you don't want to commit the current session, investigate if Autonomous Transactions will solve your problem.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
