1, online to find a lot of is to insert a Empty_Blob () and then update, who have examples to solve, please everyone a great god
2, in addition I read data, with fecth () takes a lot of, also have example batch fecth data?
3, also want to ask, OCI interface, when reading data is done in OCIStmtExecute, save the data to a local buffer, or through a OCIStmtFetch a read from Oracle

CodePudding user response:

A,,,,,,,,,

CodePudding user response:

BLOB you also want to bulk, strips is not quite good

CodePudding user response:

BLOB of batch read and insert didn't solve, other data batch read and insert address... Our side involves import and export of large data, batch can speed up

CodePudding user response:

Fix, junction, look at the official documentation for these parameters with usage, slightly to fill a breakdown

CodePudding user response:

After see documentation and caught testing, found OCIStmtExecute just establish a contact and oracle server, with a small amount of data communication, the fetch () time is really to get the data, but the BLOB data and a special, when OCILobRead, will also take the data from the oracle server to come over,