| how to find the values that have been passed to a update statement to the server [message #60625] |
Fri, 20 February 2004 12:29  |
Julia
Messages: 30
Registered: December 1999
|
Member |
|
|
Hi, my problem is the application change different jdbc driver and something went wrong. the app log shows the data on the application server is all fine, ie, with the data you can to update on the server or though any other client tools without any problem. but when the update was sent by the app server to the database it got the ora-2291: integrity constraint violated. Now we want to find what exactly the data received on the server for the update is. Since they all use binded variable so trace file does not show the values. we tried trigger but since trigger can not commit so when the TX failed everything get rooled back. the rest we can think about is use UTL_FILE in the trigger and write the values to a system file. we also though to change the app to hard code the values but seems like it's almost impossible for this application. So other than the above, is there any other way we can find out the value pass to the update on the server?
Thanks,
julia
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
