Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> problem with piecewise insert with oracle 8i
Hi!
I have to write large binary data into a LONG RAW column. To avoid an out of memory error I tried the piecewise writing following the sample code and the Oracle documentation.
Now my code does following:
open statement:
write piece:
close statement:
When running I insert som zero length columns, then one with 74 bytes, some with zero length, some with a length less 74 bytes again and then come 261 bytes of data and an ORA-24307 (invalid length for piece).
All I've found out is, that no data larger than the first one can be
inserted.
All commands are running in one transaction.
Since the maximum column size is set with the OCIBindByPos and the piece size is set with the OCIStmtSetPieceInfo I have no clue why it does not works.
Maybe someone can help me?
Thanks
>tilo
P.S.: I am sorry for linguistical mistakes ... I prefer german ;)). Received on Tue Jun 04 2002 - 09:53:13 CDT