TOraQuery->GetObject ("ObjectName") fails with Invalid Attribute Name Exception

[Morelli]

Hi Folks,

we have migrated our Project from XE to XE6 C++ Builder and updated to the ODAC Version 9.4.12.

Since this migration (without any code-changes) we get the Problem that the following code throws sometimes a "Invalid Attribute Name"-Exception:

Code: Select all

TOraObject* sdoGeometry = TOraQuery->GetObject ("SHAPE");
MSdoGeomType sdoGtype = sdoGeometry->AttrAsInteger["SDO_GTYPE"]; //Exception here

Randomly this code throws or works! Some times it works, and some times not!
The Problem seems to be the first LOC, due the TOraObject is not correctly getted!

The TOraQuery is properly initialized and ObjectView = true.

Is there a known issue concerning this Problem - is there a Workaround?
Or are there newer techniques to get an Object from a TOraQuery?

Thanks for your help!

[AlexP]

Hello,

Please send a complete sample reproducing the problem, since simple retrieving of the object attribute doesn't reproduce the described situation.

[Morelli]

Is there a known issue concerning this Problem - is there a Workaround?
Or are there newer techniques to get an Object from a TOraQuery?

Thanks for your help!

[AlexP]

For access to an attribute by name, you can use the following code:

Code: Select all

  ShowMessage(IntToStr(OraQuery1->GetObject(L"SHAPE")->AttrAsInteger[L"SDO_GTYPE"]));
  ShowMessage(IntToStr(OraQuery1->FieldByName(L"SHAPE.SDO_GTYPE")->AsInteger));