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:

• OCIHandleAlloc
• OCIStmtPrepare (update or insert with bind vars)
• OCIBindByPos (with OCI_DATA_AT_EXEC for the LONG RAW column)
• OCIStmtExecute

write piece:

• OCIStmtGetPieceInfo (to get the handle)
• OCIStmtSetPieceInfo (to set piece size and buffer)
• OCIStmtExecute

close statement:

• OCIStmtGetPieceInfo (because I don't know the EOD until I get a close message I write a zero length piece as OCI_LAST_PIECE)
• OCIStmtSetPieceInfo
• OCIStmtExecute
• OCIHandleFree

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