Is it possible to use batched inserts with BLOB fields?

[RPS]

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

Code: Select all

MDSYS.SDO_GEOMETRY(2001,NULL,MDSYS.SDO_POINT_TYPE(:p_x,:p_y, NULL)

where p_X and p_Y are simple floating point values.
In my code (in a loop) I can then use

Code: Select all

OraSQL.ParamByName('p_x').ItemAsFloat[iBatch] := RoundTo(Point.X, -2);

etcetera.

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;

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?

[AlexP]

hello,

Unfortunately, at the moment, the ItemAsObject property is not supported for parameters. We will investigate the possibility to implement this feature in the future.

[RPS]

Thank you for answering the question.

[gezas]

Hi,
is it expected that you add support for this?
Regards
Geza

[AlexP]

We don't plan to add such functionality for the time being.
You can add your suggestions on new features at our UserVoice page https://devart.uservoice.com/forums/104 ... components , and if your idea gets enough votes - we will implement it.