| Record not getting committed [message #59427] |
Tue, 18 November 2003 22:14  |
Pampan Gowda
Messages: 1
Registered: November 2003
|
Junior Member |
|
|
Hi,
In our application, we use procobol utilities to update Oracle 8.0.6.0 tables. In one case, it is found that the transactions do not get committed to the required tables and there is no error being returned to the user thru the pro-cobol utilities. Is there any way to find out the result of the transaction in Oracle, whether it is committed/rolledback/ended in error. (We are not the DBAs, is there any way to check as the developers)
|
|
|
|
|
|
| Re: Record not getting committed [message #59431 is a reply to message #59427] |
Wed, 19 November 2003 05:41  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
|
Well,you could query the tables for modified rows (you would know what the transaction is supposed to do ) after the transaction is complete(say after the session of interest terminates).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
