Home » Developer & Programmer » Precompilers, OCI & OCCI » Issue with Pro*C/C++ application (Pro*C/C++ release in HP-UX)
Issue with Pro*C/C++ application [message #329648] Thu, 26 June 2008 02:34 Go to next message
Messages: 1
Registered: June 2008
Location: bangalore
Junior Member
I am using Pro*C/C++ Release 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++ application [message #333489 is a reply to message #329648] Fri, 11 July 2008 22:12 Go to previous message
Messages: 49
Registered: April 2008
Location: Brighton, Michigan
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

Cool 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.
Previous Topic: multithread program hangs in Oracle Library on Itanium
Next Topic: SQLCODE values
Goto Forum:

Current Time: Tue Feb 07 06:37:28 CST 2023