This content has been marked as final. Show 3 replies
If the data is more than the capability of ub2 you can use OCILobWrite API. The API takes an ub4 for data amount parameter
But OCILobWrite API was expensive for inserting blob.
These were my test results for inserting array of blobs:
1.OCIBindByPos(), OCIBindArrayOfStruct(), the Parameter of dty taking SQLT_BIN,would takes least time and reduce the round trip.But it had a limited in the capability of ub2.
2.Using OCIBindByPos() ,with the Parameter of dty taking SQLT_BIN, to insert blob one time just for one record, would takes more round trips, and takes more time, without the limited in the capability of ub2.
3.Although OCIBindByPos(), OCIBindArrayOfStruct(), OCILobWrite ,the Parameter of dty taking SQLT_BLOB, would reduce the round trip, takes more time than condition 2.
4.OCILobArrayWrite() might be a good choice,but it was one of these Oracle Database 10g Release 2 functions,and my Customer demand was in platform of Oracle Database 9i.
How could I improve the performance for inserting blob,at least greater than the condition 2?
Please go through these links to see if it helps