| The incorrect no of records in fetch [message #93525] |
Tue, 07 May 2002 22:11  |
Bipin sahani
Messages: 5
Registered: January 2001
|
Junior Member |
|
|
Hi All,
We have migrated our application for Pro*C 2.0 and Oracle 7.x to Pro*C 3.0 and Oracle8i.During testing of one specific code we encountered the following problem.
While fetching data from table for specific query we are getting no of rows less than the same query returned onSQL pronpt using batchfech.The problem is persisting on HP11 and sun solaris 2.8
When batch fetch changed to single fetch the query start giving right no of rows as it was returning on SQL Prompt.Can anyone throw some light on thsi why this happening ??And how we overcome this problem without changing batch fetch to single fetch.
Any help in this regard will be greatly appreciated.
Thankx and regards,
Bipin
|
|
|
|
| Re: The incorrect no of records in fetch [message #93526 is a reply to message #93525] |
Wed, 08 May 2002 01:11  |
Giridhar
Messages: 38
Registered: May 2001
|
Member |
|
|
Hai Bipin,
I have few doubts.
(01) were you getting proper output before this migration or you are getting this problem only after migration?
(02) You want this program to work on Array fetch.
So can you please check for the array size while declaring the variables.If you can send the piece of code where you declare the variables and where you fetch it would be useful for me.
If the program is not a big one, you can send it to me at giridhar123@yahoo.com.
Regards,
Giridhar Kodakalla
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
