Devart Forums

Does ODAC (net:=true) support SDO_GEOMETRY datatype?
If yes... is there any example how to work with it? (read/write)

Thanks for help.

Matej

No, Net option doesn't support objects.

Thanks for answer.
Then I should "go" through OCI.
Eny examples about this? (how to "correctly" access this field) Any user experiences?

I will be very thankful for any examples. I'm new with this field types and I 've got task to read data which is written in WKT (well known text) and wrote it to SDO_GEOMETRY field (and vice versa).

Matej

We have no demo for SDO_GEOMETRY object type. Please refer to our Objects demo.

Is any other user here (forum user), which will be kind enough to share with me little example how to correctly work with this type?

Thanks.

Matej

Here is a sample code, feel free to use it

Stefan


private
FQuery: TOraQuery;
FOrdinates: TOraArray; // Ordinates Array
FElemInfo: TOraArray; // Eleminfo Array
FSDOPoint: TOraObject; //
FElemIndex: integer;


procedure TSpatialLoaderStruktur.LoadGeometry;
var
Geom: TOraObject;
GType: integer;
Begin
Geom:= FQuery.GetObject(FGeomFieldName);
FSDOPoint:= Geom.AttrAsObject['SDO_POINT'];
FElemInfo:= Geom.AttrAsArray['SDO_ELEM_INFO'];
FElemIndex:= 0;
FOrdinates:= Geom.AttrAsArray['SDO_ORDINATES'];
GType:= Geom.AttrAsInteger['SDO_GTYPE'];
FDim:= GType div 1000;
GType:= GType mod 1000;
FIsComposite:= False;
//
LoadElement(FElemInfo.Size, GType);
End;

I am just evaluating Oracle Data access components for Delphi7

I think this thread may hold the answer to the problem I've got with SDO_GEOMETRY returning 99 values 96 of which are null.

Wht does the call to LoadElement refer to in Aufhauser' example.

i.e. what class does the method belong to and what unit does it reside in

Many thanks

Nigel

I wanted to give an example, how to use the single elements of
mdsys.sdo_geometry type.
I used a code fragment of my own code and forgot to clear the line "LoadElement".

Stefan