Re: Array fetch problem (ORA-24371)

domosoft_at_my-deja.com wrote:
>
> I migrating From Oracle v &.3 to Oracle 8i.
> under AIX version 4.3.
>
> In the Proc*C program we use array fetch without indicator.
> The program finish with core dump (segmentation violation) and the
> following oracle error appear ORA-24371. (check the documentation for
> the fun)
> I reduce the program to test the array fetching and I remark that the
> process run if we put indicator variable. But I have a lot of jobs
> without indicator..
>
> Is someone have an idea how to correct this problem without put
> indicator in the code.
>
> Thanks
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Is it safe to assume you must be using the "unsafe_null" parameter to get your code to compile?

If you are getting a segmentation fault then it probably means that one of your host variables is not large enough to hold the value that is being passed by the cursor and thus you are overrunning storage.

However, there simply are no good excuses for not using indicator variables. They are not that difficult to code and they are there for a reason. Good coding practices would always include indicator variables. Received on Wed Dec 29 1999 - 13:36:46 CST