| Issue with Pro*C/C++ 10.2.0.2 application [message #329648] |
Thu, 26 June 2008 02:34  |
ckmsasi
Messages: 1
Registered: June 2008
Location: bangalore
|
Junior Member |
|
|
Hi,
I am using Pro*C/C++ Release 10.2.0.2 in HP-UX. But Pro*C/C++ application was written long back during oracle release 8. Now we are facing a problem like EXEC SELECT query is not fetching the records even though record is present in DATABASE.
This is not happening every time. This problem starts happening only after heavy use of the unix process.
For every request, unix process will fetch the record and updates the same at the end and process goes to wait mode to get the request again. Let say after 50 request, process is returned with no rows found error.
It started working fine only after restarting the process and problem starts again after 50th or 60th request. This problem we are facing only after upgrade to 10g.
Please helps us in resolving this issue. Thanks in advance.
|
|
|
|
| Re: Issue with Pro*C/C++ 10.2.0.2 application [message #333489 is a reply to message #329648] |
Fri, 11 July 2008 22:12  |
TheSingerman
Messages: 49
Registered: April 2008
Location: Brighton, Michigan
|
Member |
|
|
Here are some of the unknowns which you left out:
1) Oracle client software version, before and after.
2) Was application recompilied
3) Was application relinked? If so, with which version?
4) Some brief pseudo code of your process.
5) Where do commits happen
6) How is this unix process interacting with everything else
7) How many different caches do you have working here
 How many concurent users
9) You didn't change user clients on us (fat VB to web, or VB to .NET, or JVMs) did you?
I think if you look at the answers to all of the above, the source of your problem will be obvious.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
