Is it possible to use batched inserts with BLOB fields?
Posted: Sun 19 Aug 2012 15:06
I am working with GIS data, using SDO_GEOMETRY fields.
I can upload point data in batch mode, using a TOraSQL,
settings its ArrayLength property to a large value e.g. 1000,
using an SDO expression like
where p_X and p_Y are simple floating point values.
In my code (in a loop) I can then use
etcetera.
I also want to upload polylines, polygons, multipoints and that sort of geometries,
but then I need something like
where MyGeometryObject is some binary object.
Problem:
There does not seem to be an 'ItemAsBlob' or similar method which works as an array.
Am I missing something here?
What is the way to insert blobs in a faster way than one by one?
I can upload point data in batch mode, using a TOraSQL,
settings its ArrayLength property to a large value e.g. 1000,
using an SDO expression like
Code: Select all
MDSYS.SDO_GEOMETRY(2001,NULL,MDSYS.SDO_POINT_TYPE(:p_x,:p_y, NULL)In my code (in a loop) I can then use
Code: Select all
OraSQL.ParamByName('p_x').ItemAsFloat[iBatch] := RoundTo(Point.X, -2);I also want to upload polylines, polygons, multipoints and that sort of geometries,
but then I need something like
Code: Select all
OraSQL.ParamByName('p_geo_object').ItemAsBlob[iBatch] := MyGeometryObject;Problem:
There does not seem to be an 'ItemAsBlob' or similar method which works as an array.
Am I missing something here?
What is the way to insert blobs in a faster way than one by one?