Understanding the fields in oraca....
From: George Guntensperger <guariba_at_hotmail.com>
Date: 10 Dec 1998 15:04:06 GMT
Message-ID: <01be244d$fde6ddc0$0264c8c0_at_george>
I have an aplication in proC/C++ that presents a strange behaviour. The same information is requested from a table in different times. In one time oracle returns the correct response, another it send me an error 1403 - no data found. If a select is make in another table with other purposes and another request is make for the select with problem, this select works.
Date: 10 Dec 1998 15:04:06 GMT
Message-ID: <01be244d$fde6ddc0$0264c8c0_at_george>
I have an aplication in proC/C++ that presents a strange behaviour. The same information is requested from a table in different times. In one time oracle returns the correct response, another it send me an error 1403 - no data found. If a select is make in another table with other purposes and another request is make for the select with problem, this select works.
Since the information requested exist in table I have a suspicious for a cursor problem. Then the oraca was enable to trace cursor cache.
There I find that the number of opened cursors never reduce. It grows until MAXOPENCURSORS just like that any sql statement that make an implicit or explicit cursors was never closed.
What's happening ? Received on Thu Dec 10 1998 - 16:04:06 CET