This content has been marked as final. Show 2 replies
I would run a client trace (since you are using the OCI driver) and -- more importantly -- a server trace to see what is going on.
You say that both the insert and the subsequent select run in the same session? Weird.
Is the server a single instance or a RAC?
Thanks for your reply, looking forward to make changes in sqlnet.ora to trace client/server.
Also, requirement is as such that we have insert and subsequent select. (Will insert one row with 2 column values and one column value is autogenerated, in select we are capturing the autogenerated value in insert.)
Server is RAC.
Also the same insert/select was working fine when we were using oracle9i client with oracle 9i server on jdk 1.4 on Sun One Application Server 7.