Re: OCI piecewise insertion troubles

Clair Roberts schrieb in Nachricht <347A21F0.D5CFCAB4_at_pangaea.ca>...
>I have been having trouble getting a piecewise insertion to work.
>
>I have followed the examples in the manuals to the tee and not had any
>success. (Most likely because I followed the manuals examples)
>
>The error seems to be when I get down to inserting my last piece of the
>insertion and call the oexec, It always returns me the ORA-03129 next
>piece required message.
>
>Has anybody out there been successfull in performing a Piecewise
>insertion into a long raw filed using PROC and OCI calls??
>

I managed to insert piecewise using oci. I found out that the examples are really long. As far as i remember there were two major errors in the examples:

1. The setting of MAX_COL_SIZE is 0x80000000 instead of 0x7fffffff. The latter value is mentioned somewere else in the documentation and works. Using the first value lead to a endless loop in oexec because i didn't check the return value of obindps.
2. The setting of progvl in the insert example is also wrong. It shouldn't be the length of the first or maximum piece to be inserted instead it should be the maximum size of the column, i.e. something like 0x7fffffff also.

But in general my code does the same as the examples.

Ingo Eichenseher
Lehrstuhl fuer Angewandte Mathematik
Technische Universitaet Muenchen
www.appl-math.tu-muenchen.de/~ieichens Received on Tue Nov 25 1997 - 00:00:00 CST