| frm-40655 [message #86772] |
Fri, 29 October 2004 02:42  |
shish mate
Messages: 49
Registered: February 2004
|
Member |
|
|
hi (form 5, oracle 8i)
i'hv a form where i'm fetching data from one table and inserting that data into another table my select statement and insert statement is working fine but when ever i try to exit that form it gives me error
FRM-040655 : SQLERROR FORCED ROLLBACK : CLEAR FORM AND RE-ENTER TRANSACTION
WHAT IS THIS?
(I'M NOT ISSUING ANY ROLLBACK STATEMENT IN MY FORM.
NO DATABASE BLOCK IN MY FORM.)
help me thanks.....
ASHish
|
|
|
|
| Re: frm-40655 [message #86776 is a reply to message #86772] |
Fri, 29 October 2004 04:40  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
Commonly this error is caused by a deadlock or some other error has caused the current transaction to fail. Oracle Forms has rolled back the changes you have made in the transaction.
Use SQL*Net Trace to check for RDBMS errors and SQL*Net errors.
Check sqlnet.log file for SQL*Net V2.X errors.
HTH
Regards
Himanshu
|
|
|
|
| Re: frm-40655 [message #86777 is a reply to message #86776] |
Fri, 29 October 2004 19:52 |
ashish
Messages: 107
Registered: December 2000
|
Senior Member |
|
|
hi
thanks for reply
what is this
SQL*Net Trace i dont hv dba knowlg.
and Oracle Forms has not rolled backing the changes i have made in the transaction.
i can see thoes changes in my tables
thanks .......
regards
ashish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
