Re: Pro*C and Oracle 8i, fetch coredumps

Thanks for the suggestion.
Yes, I agree, that that would be nicer code. However I am dealing with a bunch of existing programs which have to be migrated over to a new system, and we were told that "All you'll need to do is recompile". And I guess we would prefer doing that instead of rewriting a bunch of programs the original author of which has long moved on to brighter pastures.
But if that's what we have to do, that's what we will do. My intention was to narrow down, if it is an issue with the C program, or with the database installation. (The latter is not totally unwarranted, even sqlplus would core dump on me under certain conditions, until the DBA installed a patch from Oracle support). So if anyone running 8i would be able to reproduce the core dump, I would know that it's not the DBA's fault.

Thanks

   Christian

paul cluiss wrote:
>
> Christian,
>
> I'm looking at your code. I haven't fixed it yet, but have you thought about rewriting the
> select/fetch portion so that you open a cursor, then fetch each record one at a time from
> within a loop, exiting the loop when NO DATA FOUND exception is hit? This is the standard
> practice, rather than doing one huge select into a finite structure. What happens when the
> data grows larger than your structure? Maybe this has already happened.
>
> Paul Cluiss
Received on Mon Nov 15 1999 - 12:47:40 CST