positional bind in OCI or using array interface
I'm in the course of doing some changes in the way I upload data into an Oracle Database using OCI.
At present I'm building single INSERT INTO TABLE ( :1,:2,...:300) VALUES ( 1,"long text"... etc. etc. ) and send this as
OCIStmtPrepare() followed by a OCIStmtExecute().
During this I'm getting an ORA-01704 since the text exceeds 4000 characters.
So I'm thinking about changing the bind method to BindByPosition and put the data into bind variables.
Also I would like to put the data in an array first and send only one INSERT statement hoping that this also may speed up things.
Could someone give me some starting aid, maybe a sample code piece or so?